Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maintaining Links when moving data
I have a worksheet that tracks data for a certain amount of time (Sheet1!$C).
Several of the cells from Sheet1 are linked to cells in Sheet2 via IF statements. Once the date range for the data in Sheet1!$C has expired I move those rows over to Sheet3 (copy/paste). I'd like to know what my options are for redirecting the IF statements in Sheet2 once I move the Shee1 data. Please note that while the columns stay the same the row #'s do change between Sheet1 and Sheet3. Any assistance would be appreciated. Thanks much! -- Teri Albert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving xls files that have links?? | Links and Linking in Excel | |||
Maintaining links when copying entire directories | Links and Linking in Excel | |||
Moving Links in Excel | Links and Linking in Excel | |||
Maintaining links when renamining/moving files | Excel Discussion (Misc queries) | |||
Maintaining numerical data with <'s in pivot tables | Excel Worksheet Functions |