Comparing Data From Two Sheets

[kush516]

Hi Guys,

I'm relatively new to Excel VBA and macros and I'm currently struggling to create a macro that would compare data from 2 sheets to find matching values and copy&paste them into the sheet named Product Info tab.

1) In the excel sheet there are two tabs called Product Info tab, and Full Image Links with UPC tab.

b) There are UPC numbers in both the sheets , but not in the same row. So I need a way to find the matching UPC Number from sheet "Full Image Links with UPC" and paste it to the correct row in "Product Info sheet"

I have done the first row in "Product Info sheet". so if I do this manually its gonna be a time consuming task. Hence could you guys please help me with a VBA code or formula to do this?

[TMS]

See the yellow banner at the top of the page