Loop until cell values match then copy, move to next cell and loop and copy again

Trying to copy a row of data from table 2 and paste it in the correct row of table 1. Then go to the second row of the table 2 and paste into the correct row of table 1, repeating the process until everything in table 2 is copied to the correct position in table 1.

Code below works fine putting the first row of table 2 where it belongs in table 1.

I just cannot figure out how to put this first loop inside a second loop that starts at the first 'Name' in table 2, does the loop in the code below, selects the second 'Name' in table 2, does the loop below, and so on until the end of all the 'Names'.

There is probably a better way to do this (VLOOKUP) but since I have started wouldn't mind knowing how to do it anyway.

Thanks

Please Login or Register  to view this content.