Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Formulas - Replace Worksheet
I am trying to help someone with a relatively simple problem. They have a
workbook with two worksheets: Calcs and Data The Calcs worksheet contains protected formulas that refer to the Data worksheet values. The user wants to be able to delete the Data Tab, insert a new tab and re-name the new tab Data. For example, if a cell in Calcs contains: =Data!A1 then after the tabs are adjusted the result should still be: =Data!A1 ANY solution,manual or VBA, is acceptable. The formulas in Calcs need to be unchanged -- Gary''s Student - gsnu201001 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I freeze individual cells with formulas in them | Excel Worksheet Functions | |||
How do I freeze formulas when cutting and pasting other cells? | Excel Worksheet Functions | |||
Freeze worksheet? | Excel Worksheet Functions | |||
Replace all formulas in one worksheet to link to different worksh | Excel Discussion (Misc queries) | |||
How can I freeze formulas in Excel? | Excel Worksheet Functions |