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 |
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 |
All times are GMT +1. The time now is 11:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com