Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
relative sheet macro
In Excel2000, I have a summary file that adds specific cells from two
other files (they are all the same amount of sheets). I want to be able to create a formula ( +[Book2]Sheet1!A1+[Book1]Sheet1!A1) in Sheet1. Once I have this formula, I want to copy it from sheet to sheet so that on sheet2 it reads =+[Book2]Sheet2!A1+[Book1]Sheet2!A1. I want to a macro to change the sheet # relative to the file. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
relative sheet referencing | Excel Programming | |||
Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
Make macro-button sheet reference relative | Excel Programming | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Making the Sheet a relative value? | Excel Worksheet Functions |