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
Bookmarks