Copy an entire row to a different sheet if a certain cell in a column matches criteria

I need to create an excel macro that searches through a document and if a cell in column A matches a certain name, for example "Name1" then I need it to put the corresponding row into sheet 2. There will be multiple rows that match this criteria. I also need it search column A and anything with "Name2" put that in Sheet3, and so on...

There are approximately 11 different values that I need the macro to do this for, and copy all the corresponding rows into the appropriate sheet. I would greatly appreciate any assistance that anyone can offer.

Thank you.

dmchase

Try this. Hard code the names where indicated surrounded with quotes as in "Fred". Add another Case for an additional name together with a wsheet or delete as appropriate.


hth

gmk

Please Login or Register  to view this content.

Hi
The above query and code seems to be along the lines of my query.

Where i am lost is that the keys words i am targeting are "corporate", "finance", "i.t" etc....

With the worksheets named accordingly...

What do i need to edit to make this change?

Any help greatly appreciated..... Great Site BTW

Opps...sorry