Prev: Question About Sorting
Next: Growth rate
From: Stupac on 4 Feb 2010 22:37
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
From: "Bernie Deitrick" deitbe on 4 Feb 2010 23:09
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" <Stupac(a)discussions.microsoft.com> wrote in message
news:A0F70E8C-94B1-47DC-897A-C33F10DFEEBF(a)microsoft.com...
>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

 | 
Pages: 1
Prev: Question About Sorting
Next: Growth rate