Multiple worksheet master

[Guest]

Hi,

I have 10 worksheets in an excel doc, one for each department at work. Each
worksheet is the same in terms of column structure. Is there a way to have a
master worksheet that lists all the rows from the department worksheets? It
would be useful to have a consolidated view of the data. Ideally, I would
like to be able to add rows to the department worksheets and have those rows
appear automatically in the master worksheet view. Is this possible?

Thanks!

 

[Earl Kiosterud]

Tuc,

http://www.smokeylake.com/excel/excel_truths.htm. Read "Data across
multiple sheets.