I have got an excel sheet that has got 3 sheets in a single workbook.
I need a macro that would compare the 2 columns with same headers in the 1st and 2nd sheet (i.e. compare column A and B of sheet ABC with the Column A and B of the Sheet DEF) and only if both the values in column A and B of the sheet ABC matches the values of columns A & B in sheet DEF, copy the matched data from 1st sheet along with its corresponding values in column C in the 2nd sheet to the 3rd sheet(GFH).
Sorry for too complicated explanation! Hope this is understandable.
Thank you.
Bookmarks