Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative links to worksheets
Each month I make a workbook with multiple worksheets, each day has
one or two tabs(worksheets), so that they are not numbered in a logical series. And on a summary tab, I do several calculations from the other tabs cels. Row1 has several formulas relating to Tab1, and row2 has the same forumulas relating to the Tab2, and so on. Is there a way create a new row, with the same formulas that address the next tab? I have been copying the row, which gives me the exact same formulas, then edtiing each formula by hand to change the worksheet reference. (ie changing '5.2'!N$38 to '6.1'!N$38). I have it in my head that I could possibly be able to do this in a number of ways. 1.Selecting the row and using a button to change all of the references that relate to another tab(I guess find and replace would be a good way, but that brings up file dialog box that gets me no where). 2. Linking each reference to a cel at the beginning of the row, where I could change 5.2 to 6.1 and the formulas in that row would feed off of that cel to know which tab to get the info from;but I see no way to do this. Thanks for any advice or even hints. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to default links to RELATIVE reference | Excel Discussion (Misc queries) | |||
Is there a way to do relative links in Excel? | Excel Discussion (Misc queries) | |||
Relative Links becoming Absolute Links? | Excel Programming | |||
Setting links to relative paths from ppt to xls | Links and Linking in Excel | |||
Creating Relative Links in Excel... | Excel Discussion (Misc queries) |