Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
references rename!
I have a summary sheet which collects data from identical copies of a
main scenario sheet. main is copied to main1, main2, main3 I build the references in this summary sheet as: 'main2'!cell_name When the main sheet is updated, the old copies of it are deleted and replace with the new main. In the mean time, Excel is busy nuking all the references it can no longer find. How do I tell it to stop doing this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
references rename!
"cate" wrote: I have a summary sheet which collects data from identical copies of a main scenario sheet. main is copied to main1, main2, main3 I build the references in this summary sheet as: 'main2'!cell_name When the main sheet is updated, the old copies of it are deleted and replace with the new main. In the mean time, Excel is busy nuking all the references it can no longer find. How do I tell it to stop doing this? . |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
references rename!
Perhaps instead deleting the clones you could clear cell contents of all
clones, then copy the new data onto those existing sheets. Names will stay. Alternative is to build the clones using, in each cell, references to corresponding cells the main sheet. The clones will automatically be updated when Main changes. leighton "cate" wrote: I have a summary sheet which collects data from identical copies of a main scenario sheet. main is copied to main1, main2, main3 I build the references in this summary sheet as: 'main2'!cell_name When the main sheet is updated, the old copies of it are deleted and replace with the new main. In the mean time, Excel is busy nuking all the references it can no longer find. How do I tell it to stop doing this? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i rename a sheet if the rename tab is inactive? | Excel Worksheet Functions | |||
How to convert all 3d references to normal references in a workboo | Excel Discussion (Misc queries) | |||
How to convert all 3d references to normal references in a workboo | Excel Worksheet Functions | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) |