Tweak Macro to return entire row if match found

Originally Posted by capson

This macro looks for matches of the cell values of col D of Sheet(1) to cell values of col B of Sheet(2) and returns the matched cell.

Is it possible to return the entire row of the match not just the cell?

Please explain what "return the entire row" means to you.

Currently the code just writes a value in column L.

Do you want to replace the existing matched row on the destination worksheet? Are the columns the same on both sheets? It wouldn't seem they are since you're comparing column D to column B.

AlphaFrog, I am sorry for being so unclear,

If say a cell d5 in col D on sheet 1 finds a match in col B of sheet 2 say B100, then on the row of the match (B100) in sheet 2 return the entire row of sheet 1 of which d5 is a member (a5 to lastcol5) to it starting in col L at row L100

This will NOT replace the existing matched row on the destination worksheet

The Columns are not the same in both sheets or the same size

I sure hope that was more clear

Thanks

First test this on a copy of your data.

Please Login or Register  to view this content.

My new macro was based on your original macro except it returns the entire row.

Your original macro compared sheet(1) column D to Sheet(2) column B

This macro looks for matches of the cell values of col D of Sheet(1) to cell values of col B of Sheet(2) and returns the matched cell.

Your example workbook doesn't have data in sheet(1) column D. So the macros (your original and my new one) will of course error. The example workbook data is not suited for your original macro or my macro. Test my macro on a set of data that your original macro worked on.

I don't follow what you're; asking, want, data config.