Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data consolidation
I created a worbook with multiple pages. I then consolidated the data. I
had to save it under a new worksbook name. In this new worksheet I need to be able to update the information and have it update the consolidated information. How is this possible |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data consolidation
Stupac,
Data should only be in one place. Get rid of the previous pages, and use data filters on the single consolidated data table to change your view to what the pages used to show. HTH, Bernie MS Excel MVP "Stupac" wrote in message ... I created a worbook with multiple pages. I then consolidated the data. I had to save it under a new worksbook name. In this new worksheet I need to be able to update the information and have it update the consolidated information. How is this possible |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Consolidation | Excel Worksheet Functions | |||
Data Consolidation | Excel Discussion (Misc queries) | |||
data consolidation | Excel Discussion (Misc queries) | |||
Need how-to or example for data consolidation | Excel Worksheet Functions | |||
data consolidation | Excel Discussion (Misc queries) |