copy sheets for formula

  • Thread starter Thread starter afdmello
  • Start date Start date
A

afdmello

if I have a cell C1 as =october!AG24
How do I go about with to get cell D1 as =November!AG24 ?
where November! is the next sheet in a series

in other words can I accomplish the fill series command for sheets with the
cell reference same in series or not?

Afd
 
What you could do is to insert a new row at the top of your sheet, and
in C1 you can enter October, and in D1 November etc, i.e. put the
sheet names (exactly as they appear in the sheet tab) in the top row.
Then in C2 you can use this formula:

=INDIRECT("'"&C$1&"'!AG24")

Note the apostrophe between the quotes and before the ! - this copes
with spaces in the sheet names.

You can copy this formula across into D2 etc.

Hope this helps.

Pete
 
Back
Top