Worksheet Problem - Need all sheets to populate one

S

starky5

I have a excel doc that has 4 tabs(sheets) named AIX, HPUX, Windows
Other. Each sheet is a listing of all our servers of each type and th
relevant info on each (hostname, location, version, vendor, dat
purchased, etc..). Each sheet is also auto-filtered on the top row b
these categories.

I would like to add a 5th sheet called "All" that list's all of ou
servers on one sheet. Is there a way to create this sheet so i
automatically gets it's data from the other sheets and is updated whe
the others are updated?

Thanks
 
D

Dave Peterson

I think it would be much safer to either put all your data in one worksheet and
then separate it into "report" worksheets on demand.

Or keep all your data on separate sheets and then copy them back to a single
workbook (on demand).

But if it were me, I'd keep all the data on a single sheet. Add a column for
Source (AIX/HPUX/etc) and then apply filters whenever I wanted a subset.

By keeping the data in one worksheet, lots of things become
easier--charts/pivottables/sorts...
 
Top