Excel Sheet Comparison Macros
Posted on 2016-08-02
I need to compare data between two sheets in one workbook. The worksheets has columns with different headings including: Promise Date,Planned ShipDate, Account Item, Item No... etc. The list has over 1000 rows. Every week, the list is updated: old orders are removed, and new orders are added. I'm planning on having the previous week's order log on Sheet1 and the current week's order log on Sheet2. I'm looking for a macro that would highlight differences by cell, but not by location. For example, the 4th column (Sales Order Number) would be the fixed variable in each row, and the macros would recognize if values in the same row had changed. Additionally, if an order appears on the old list, but not on the new, it would be deleted. I've attached a file to show the example of the column headings.
I'm very new at Macros, so I'd highly appreciate someone walking me through this.