Worksheet X reference MS Excel 2007
 

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

Worksheet X reference MS Excel 2007
 

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

Worksheet X reference MS Excel 2007
 

I have very basic MS Excel knowledge. Can you go into detail, please?
--
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

Worksheet X reference MS Excel 2007
 

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

Worksheet X reference MS Excel 2007
 

I'm happy to help you to help yourself.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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