Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm working on a home budget, and I've made 26 sheets (labeled 1-26, aptly).
Each of the sheets calls the previous information from the other sheets, and if I change something (say add a cost of 100 dollars to one column), it retroactively affects the other sheets. It took a long time for me to physically go in and change the equations on each sheet to call the previous sheet - every time i have to make a change, i have to change 26 sheets. Example: = '1'!F20 + D20 - E20 on '2' = '2'!F20 + D20 - E20 on '3' etc... I was wondering if there was a way to call the name of the current sheet as a variable in an equation, in such that I could write an equation like this: = '('currentsheet' - 1)'!F20 + D20 - E20 That way I could simply use the same equation in all 25 sheets following sheet 1. Is there such a way? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to add formula calling up current workbook when sheet copied | Excel Discussion (Misc queries) | |||
Calling a Userform from a Predefined Variable | Excel Worksheet Functions | |||
Calling a procudure through variable name | Excel Discussion (Misc queries) | |||
calling variable within string | Excel Worksheet Functions | |||
Calling a bit of code from a sheet errors | Excel Discussion (Misc queries) |