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
 

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

Update several ppt documents from a single excel file 0
Change Microsoft A3 license users to A1 by power shell script 0
Update data to match based on like datasets 2
External cell reference between two excel worksheets both in One Drive 0
Excel formula help for calculating freight. 2
Match issue 3
Autonumber field in Excel that behaves the same as Access 0
Auto Change Formulas - Please Help. 2

Top