| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Generically reference the previous workssheet
I have a workbook w/ several sheets. A few cells in each sheet accumulative
sums of data from all the previous sheets. I've been doing this w/ a cell formula like "=C14+SheetN!F14" where SheetN is the name of the previous sheet. If I reorder the sheets or add a sheet in between others, I have to resetup all affected cum cells since the name of the previous sheet changed. Is there a way I can change this formula to something like "=C14+(currentsheet-1)!F14" to generically reference the previous sheet Thx for your help, John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference to previous cell (always) | Excel Discussion (Misc queries) | |||
| Reference previous page | Excel Worksheet Functions | |||
| Remove previous file reference | Excel Discussion (Misc queries) | |||
| Reference Previous Sheet | Excel Worksheet Functions | |||
| How to reference to the previous worksheet regardless of title? | Excel Worksheet Functions | |||
Threaded Mode
