fill command - change sheet

M

mm

I have this formula " ='098'!$D$6 "
I need to change the sheet 098 to sheet 099 then to sheet
0100 and so on. Does anyone know if this is possible and
if so, please send the command line or script.

Thanks, m
 
J

Jason Morin

If the formula started in row 1, use:

=INDIRECT("'0"&ROW()+97&"'!$D$6")

and fill down. More generally, use:

HTH
Jason
Atlanta, GA
 
Top