Excel Fill Series

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series fill only copying and fill series greyed out 1
I need a macro that runs other macros until P5>=28 6
fill series of multiple rows and columns 4
EXCEL - IF(IFERROR(VLOOKUP question 0
Fill Series for Lookup 2
Macro that uses a cell value to copy another cell 3
Drag down the cell links of multiple sheets 5
SUMIF function and cell /sheet reference 3

Back
Top