Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Relative Worksheet references
Is there a way around the fact that you cannot use a relative reference for
the Worksheet? I want to use the ending balance from June to automatically populate into the July opening balance. I have a new worksheet for each month. The formulas copy and update except for the prior worksheet reference. Is there a way to get the worksheet to look at the one before it to get these figures? Right now I use =June!E9 for the July beginning balance, but when I copy the worksheet to make one for August the formula stays =June!E9. I would like it to update to =July!E9 (or whatever it takes to get that data) without having to go through and manually change each line item. Thanks for any input. I have been browsing the questions and answers here and realize that I knew Office 97 pretty well, but am totally lost in Office 07! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
Excel: Relative worksheet references? | Excel Discussion (Misc queries) | |||
Relative references | Excel Worksheet Functions | |||
Relative references | Excel Discussion (Misc queries) |