I have 2 worksheets for doing matching. The matchings goes like if column A = column A and column B = Column B in both worksheets, then match column E, and highlight those unmatched cell in column E in sheet1. Besides that, also highlight those items which appear in sheet1 but not found in sheet2.
Can this be done just using built in formula in Excel or I need a macro for it?
Thanks for helping.
Can this be done just using built in formula in Excel or I need a macro for it?
Thanks for helping.