Here is what I'm trying to do.

I have a spreadsheet of over 700 names that is a roster of all employees in
this facility. Another column indicates which department number the employee
works in. I would like to create several department worksheets that would
reference this master sheet and produce a roster for each department.

Can this be done?

The end result would be a master sheet and then several department sheets.
Each department sheet would refer to the master to populate itself. This
way, when the master gets updated, I just put the updated master in and the
department worksheets update themselves.

I think a Pivot Table would handle this nicely...


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=381014