Macro To Match Columns & If True Copy Row - How?

Hi, I have a list with multiple unique numbers and then a list with a single corresponding unique number but next to the single entries are the surnames and forenames. I want to copy them over to the mulitple entry fields. For example:

Enrol Ref No Surname First Forename
0305526 0305526 ISMAIL AWRENG
0305526 0503253 ZAHID SOHAIL
0305526 0509352 HOLTEN THOMAS
0305526 0608249 BROWN REBECCA
0305526 0702933 BELLWOOD PAIGE
0305526 0703808 CARROLL GEORGINA
0305526 0704205 GARTERY JORDAN
0374016 0708721 HAHAA KAREM SARAH QADER
0374770 0708907 SHARIF KARWAN
0503253 0708916 MOHAMMED TALAR
0503253 0800413 BROOKS LEONA
0503253 0800420 BEAUMONT MICHAEL
0503253 0800501 CLAYTON JASMIN
0503253 0802033 HALLSWORTH KRISTIAN


A = Enrol
B = Blank
C = Blank
D = Ref No
E = Surname
F = Forename

I want A to match D and where it does match D I want it to copy the row for E and F next to it on to B and C. In other words in the example above (and attached) A2 to A8 matches D2, how do I then get it to copy E2 and F2 over to B2-B8 and C2-C8.

How do I do that? I'll attach a small sample as the actual one runs in the thousands.

A2-A15 and B2-B15 and C2-C15 should look like this:

0305526 ISMAIL AWRENG
0305526 ISMAIL AWRENG
0305526 ISMAIL AWRENG
0305526 ISMAIL AWRENG
0305526 ISMAIL AWRENG
0305526 ISMAIL AWRENG
0305526 ISMAIL AWRENG
0374016 No Match No Match
0374770 No Match No Match
0503253 ZAHID SOHAIL
0503253 ZAHID SOHAIL
0503253 ZAHID SOHAIL
0503253 ZAHID SOHAIL
0503253 ZAHID SOHAIL

This is indeed not only duplicate post, but Fortis has provided you the exact result as per your requirements.

How do I delete this thread?