VBA Match?

[Puppies72]

Hi all,

In sheet test I have data in columns A through N, in sheet current I have data in columns A through BA

What I want to be able to do is take the value in !test B1 and find that exact match in !current column C (data is alpha numeric), once the match is found I need to copy the values from !test C1:J1 to the corresponding row in !current D:K, it needs to loop until an empty cell is found in !test column B

As always any help greatly appreciated

 

[Puppies72]

I posted this very late last night so thought I'd give it a gentle nudge to see if anyone has any idea how to do this

thanks