Data matching and copying

[RobbieL]

I have two sheets of data (Sheet1 - A9:AC8948, Sheet2 - A1:BS135698).

I wish to match the reference number in range A10:A8948 (Sheet1) with range A2:A135698 (Sheet2). If there is a match, I want to copy the data in the row on Sheet1, to the corresponding row for the match in Sheet2 - starting from column BU.

I've spent a few hours trying to do this but with no luck. Can anyone give me any pointers?

 

[RobbieL]

I should add that i'm trying to do this in VBA using the find function..........

 

[RobbieL]

Anyone? Still stuck on this......

Cheers