Thanks Don,
I figured it out and wow, what a great tool.

--
Glenda


"Don Guillett" wrote:

Or, all on one with a column for DEPT and then use datafilterautofilter

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Glenda" wrote in message
...
I would like to have a worksheet that has all of the data (the main
worksheet). I would also like to have 5 'sub' worksheets. Each sub
worksheet would show data from the main worksheet that pertains to that
department - the department is listed in column 'N' of the main worksheet.

I appreciate input to the easiest way to accomplish this. I am working
with
MS Office 2007. Thanks for your help