Macro VBA to comapare two sheets to find duplicate values

[sumera12]

Hi,
I am currently working for data validation team. I have to validate tons of data every week so it would be great if i could remove dupicates.

I want to compare two worsheets, sheet 1 has the order number with description (which i have to find) for the current month and sheet two has got standard report from the past week giving all the order numbers with no description. I need a VBA based macro to find all matching order numbers which are in sheet 1 column A, in sheet2 column A and return the corresponding value in column B in sheet 2 and also return the description in Column C. I have attached a dummy workbook.

Please respond.

Thank you

[MickG]

Try this:-

Please Login or Register  to view this content.

Regards Mick

[sumera12]

MICKG

Thank you so much! works like a charm.

have a great day

[MickG]

Your're welcome
Regrds Mick