Compare two worksheets, find first match and paste, then delete source row

[LuigiC]

I have two worksheets and want to paste two cells from the second worksheet (Sheet1) when find the first match in active sheet. Then delete the source row in Sheet1. I can't loop from the last row of the active sheet because I want to populate the first row from the top that matches. I'm also struggling to activate Sheet1 in order to delete the row

Please Login or Register  to view this content.

Attached a pic of sheet1 after the code has run...

sover.jpg

[:) Sixthsense :)]

Lot of junks in your code...

What is the need of this with statement since none of your code uses it...

Please Login or Register  to view this content.

Is it i or n??

Please Login or Register  to view this content.

Just use this code for this "'need to delete the source row in Sheet1"

Please Login or Register  to view this content.

[LuigiC]

Oh dear I got the sheet name wrong, it should have been Sheet2 as below. The active sheet is sheet1 but it needs to go to sheet2 to get the matching values as below

Please Login or Register  to view this content.

[mike7952]

Be best to upload an example workbook with your desired output

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[LuigiC]

Thanks, this is good but I need to think this through a bit more
Cheers, L