The filters are not what I need. I need this to be on separate reports which
are automatically generated when a row is added to the main sheet.

I am interested in going the macros route since I don't have tons of time to
spend trying to figure this out. Please respond with instructions assuming
that I know nothing about the procedures for using macros. That would be a
correct assumption.

Thanks so much for your help.

Lorie

"Bernie Deitrick" wrote:

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.