Actuary1010
07-20-2011, 07:36 AM
Hello guys,
Thank you all for this wonderful forum!!! I've a problem that I believe it's not hard but I'm not quite sure how to tackle it. I would really appreciate and help and suggestion. Here it is:
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.
I only need to compare the first 65 columns (up to column "BM").
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 columns only).
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 changes.
In summary, I want a nice sheet that highlights the changes.
Thanks in advance, and I would really appreciate any help.
AA
Thank you all for this wonderful forum!!! I've a problem that I believe it's not hard but I'm not quite sure how to tackle it. I would really appreciate and help and suggestion. Here it is:
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.
I only need to compare the first 65 columns (up to column "BM").
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 columns only).
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 changes.
In summary, I want a nice sheet that highlights the changes.
Thanks in advance, and I would really appreciate any help.
AA