Copying the details of a code based on their unique identifier.

Greetings excel people =)

I was trying to do a Macro that will copy the entire row of a cell from sheet 2 using cell from sheet 1 as the unique reference "ASSET CODE".

It was like a vlookup technically on a larger scale, instead of having 1 cell as an answer, it will be the entire row.

I'm hoping from all of you guys, the data is quite big to find it one by one.

Thank you in advance,


Please see attach file for your reference

I was going to attach the code with the sample, but it is too big and exceeds forum's limit.

Please Login or Register  to view this content.

What theeee... ahahahhaha... Super Duper Thanks AB33.. Its fully working even if I add new data on the Asset Records.. Thanks Dude.. you are the best

Jar,
You are welcome!
The code clears all existing data from column B, row 2, to last and then repopulate with new data. You can add any data in column A and run the code.