Hi All,

I think I'm attempting some coding that's a bit out of my league w/
Excel/VBA. Any advice would be greatly appreciated - even if it's just
"you can't do that, stupid!".

What I'm attempting:

I have a data dump which I'm trying to parse through by looping through
all rows and copying certain rows to certain worksheets depending on
the contents of one particular column/cell within the row. I've already
covered the looping through rows, and the copying/pasting to an
existing worksheet. (Not yet the "create new worksheet" but I don't
expect that to be hard).

What I need help with is the following: I'd like excel to select all
rows in which a particular column/cell has the same value (an
employee's name - I've already sorted the data on name so all
like-employee rows are together), then copy those rows to the
appropriate worksheet. I have no idea how to say "does cell contents
match the name of an existing workbook" in VBA.

As mentioned previously, any tips would be greatly appreciated!

Thanks!

Caroline