1st and Last name

[outlawspeeder]

I'm sorting data in excel and I have to do this to many parts of the excel doc. If someone could help me with getting the bellow I could then add repeat that for the rest of the tab I have to fill in. So I am only using the 1st and last name as an sample.

What I trying to do is have a table that uses can enter 1st names into (sheet1 A3:A13). The user would then press a button and the code would look at Sheet 2 column A and find the first name.

At this piont it would get the last name in Column B. It would then use the last name to find all the rows with the same last name and copy them to sheet 3.

I think it can be done with a loop or If statment but not sure how to go about it.

Thanks for any help.

 

[nbrcrunch]

what if you had 2 or more people with the same 1st name?

 

[outlawspeeder]

As it goes down the first name gets Bob, does for the last name for Bob Jones and is none, it should go back to the first name column and finsh looking for Bob untill last line.

So if there is a Bob Jones and a Bob Davis both last name groups would be copied to the next tab.