Find and insert data between 2 sheets

[flexi1]

Hi

I have a spreadsheet where I have 2 sheets of data, I need a macro or VBA that can scroll down a column in sheet 2 and select each cell one by one and then search for the data that was within those cells in a column in sheet 1. Once it has done this it needs to insert the data that was adjacent to the data in sheet 2 into an adjacent line in sheet 1.

I have attached a sample spreadsheet to try and explain this a bit better. I need the find the RED data in SHEET 2 in the BLUE data in SHEET 1 and then copy the GREEN data in SHEET 2 along side the corresponding cells in SHEET 1

If anyone could help me do this that would be great, my actual spreadsheet has about 3500 rows and would be a bit of a task to do this line by line.

Many Thanks

[Kaper]

Try in B1 (sheet1):

Please Login or Register  to view this content.

copy this cell down