In a fill series how do I increment the sheet number but not the cell i.e.
sheet1!F1, sheet2!F1, sheet3!F1 and so on.

Hi
in A1 enter
=INDIRECT("'sheet" & ROW() & "'!F1")
and copy down

"electromott" wrote:

In a fill series how do I increment the sheet number but not the cell i.e.
sheet1!F1, sheet2!F1, sheet3!F1 and so on.

One way

=INDIRECT("'Sheet"&ROW(1:1)&"'!F1")

obviously it will only work if the sheets have the same name plus a number

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"electromott" wrote in message
...
In a fill series how do I increment the sheet number but not the cell i.e.
sheet1!F1, sheet2!F1, sheet3!F1 and so on.