Compare cell from two sheets, copy entire row to current sheet

[nguerra]

I have some data in column A of sheet 2. What I need is to copy over every row on sheet 1 that matches A2 sheet 2 to B2:B(till end) of sheet 1. Once done with cell A2 of sheet 2 go to cell A3 and do the same appending to the rows on sheet 2. Continue till the end of data on sheet 2. Attached is what my file currently looks like.compare-copy-row.xlsx

[DarthVader68]

I don't completely understand your question, the code will look into every cell in column A Sheet2, if it matches the adjacent cell in column B Sheet1, then it will copy the adjacent data from column C:G Sheet1 to A2 Sheet2:

Please Login or Register  to view this content.

ZAX

[nguerra]

Zax, I think it's close but when I ran your code in the file I uploaded it stopped after the first line.

[DarthVader68]

Zax, I think it's close but when I ran your code in the file I uploaded it stopped after the first line.

Would you please give me more information? you want the code to check if the value ** column A Sheet2 is identical with the ADJACENT cell from column B Sheet1 to copy the data ** C:G from sheet1?
That's what the code does
ZAX

[nilem]

Hi nguerra,
maybe so

Please Login or Register  to view this content.