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.
only need to compare the first 65 columns.
I would like to obtain the following output in the new sheet after
running the code:
1) Keep and copy the second row (variable name) into the new produced sheet (for the first 65
2) Keep columns A, B, D, F, K, and L (I need them as identifying variables) and copy them into the
new sheet (they are similar in both sheets).
3) for the two columns “Z” and “AA”, no need to do comparison since
they will be always different, and I don’t want them to be in the new sheet.
4) Delete any row that has no
In summary, I want a nice sheet that highlights the changes.
Thank you so much in