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!

Tuc,

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

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Tuc" wrote in message
...
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!