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).
Reply With Quote