Hey everyone,
The VBA code, attached with workbook, is used to compare two spreadsheets. The output of this code creates a new sheet that shows the differences have occurred, and if no difference, it leaves the cell blank. And I would like to do the following:
1) Keep and copy the first row (variable name) into the new produced sheet.
2) Keep columns A (id), B (name), and E (comp) without comparison, and copy them into the new sheet as identifying variables (they are similar in both sheets).
3) Delete any row that has no changes.
The workbook is attached.
Thanks!!