fill command - change sheet

  • Thread starter Thread starter mm
  • Start date Start date
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
 
Jason: I didn't quite get it to work...I'm not familiar
with the "indirect" command.
 
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

Update cell value based on name and specific date 1
Dependent drop down dynamic range formula, off sheet. 7
Fill Series only changing one input 2
Auto Change Formulas - Please Help. 2
Excel A CountIF question... I think 2
Formula to a sheet name that is text in another cell 1
"='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4 5
Linking sheets which must update the date first. 3

Back
Top