Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidating data - removing consolidation
I have consolidated data from 3 sheets - and the sum is shown in the forth
sheet. I have also created a link to the source data. Now I want to remove the consolidation again - but I just can“t seem to remove this from the 4th sheet. How can I remove the consolidation and get back to normal?? Kathrine, Stavanger, Norway |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidating data - removing consolidation
Kathrine, if I understand it, after consolidating three sheets into a fourth,
you want to remove the links. If this is correct, you could select all the data in the fourth sheet and copy, paste special, values to change the link formulas to data. HTH -- Sincerely, Michael Colvin "Kathrine J Wathne" wrote: I have consolidated data from 3 sheets - and the sum is shown in the forth sheet. I have also created a link to the source data. Now I want to remove the consolidation again - but I just canĀ“t seem to remove this from the 4th sheet. How can I remove the consolidation and get back to normal?? Kathrine, Stavanger, Norway |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
need help in consolidating multiple data | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) |