I already have a macro that will compare two worksheets and highlight differences. Now, I need a report that would be in a separate worksheet called “Report”.
Wherever there is anything highlighted in the row, I want that whole row copied and pasted into “Report” sheet. “Status” column should be marked as “Change”.
If there are any new rows in “New” sheet they should be copied and pasted in “Report” sheet. “Status” column should be marked as “Add”.
In the case that there are some missing rows in “New” sheet, but they existed in the “Old”, I want those rows copied and pasted from “Old” into “Report”. “Status” column should be marked as “Missing”.
Please see attached sample file. Let me know if you need more information. I appreciate help on this.