| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet references
Hi All is there a way for me to drag down a formula that will change the
sheet it is looking at in each new cell? lets say that in cell A1 the formula is =MySheet2!A1 As I replicate this down I want the sheet2 to increase to MySheet3, then MySheet4 etc. The sheets might not be called 2,3,4,5 etc but I need the formula to just go to the next sheet regardless of the name of it. I really hope this makes sense! Thanks again guys |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet/Cell References | Excel Discussion (Misc queries) | |||
| using cells to define sheet references | Excel Discussion (Misc queries) | |||
| rolling sheet references | Excel Worksheet Functions | |||
| Cross sheet references (=Sheet2!B4) | Excel Discussion (Misc queries) | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Threaded Mode
