I need to create a macro or a pivot table that will compare 2 spread sheets. The first will be an old report and the second will be a new report. I will need to find out what lines on the new spread sheet were not on the first one. Does anyone have any suggestions?
Will the new lines be at the bottom? Or mixed within?
What do you want to do to the "new" lines of data?
Is your data in both sheets sorted the same?
Does your data have a single value (a key value) that you can/will compare in order to find the "new" lines?
I would create a macro with a loop that starts at the top of both sheets and compares. If they match, it goes to the next row. If it does not, then do whatever action you're going to do (ex: highlight).
