Copy Row to new sheet based on list comparison

[skull_eagle]

Hi All,

I have a list of names in column A in sheet 2. I need to check for this name (all or part of name) in column C of Sheet 1. If the name is found then copy the row of data from sheet 1 to a new sheet (the new sheet should be called the search name). Once sheet 1 has been checked for the name in A1 (sheet2) then it needs to be checked for the name in A2 (Sheet2) and these should be copied to a new sheet..etc etc etc until all names have been checked and there are 50 or so new sheets.

I'm not sure if it's easier to do it this way or to instead create all the new sheets from the list in column A (Sheet 2) and then delete the blank ones after.

I'm having some major trouble and any assistance would be a life saver, Thanks

 

[skull_eagle]

That works like a charm.

Thank you so much for your help Peter, you are a true champion!