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.
|