Lorie,

You could use one sheet and apply data filters, or you could use a macro to
create the additional sheets from the main sheet.

If you want the macro, post back.

HTH,
Bernie
MS Excel MVP


"Lorie" wrote in message
...
I have a main spreadsheet that has rows of data for each project managar.
Each project manager may have multiple rows of data in the main
spreadsheet.
I would like to make new worksheets for each project manager with all
their
rows of data from the main spreadsheet. I would like to make this all
automatic since my end-users are not very computer savvy. I tried pivot
tables, but I don't want the data to sum; I want it to list. Is this
possible? I tried looking at some past postings (I saw one referenced
from
1/10/05). They were too complex for me.