Ann_BBO
11-23-2009, 02:11 AM
Hi All,
I offer my apology if this question has been presented before, but here is my issue!
In the attached file, it has 2 sheets which are “File2” and “File1” for comparison. Since the “Name” in column E is unique, I would to compare the 2 sheets base on “Name” and then output the difference to a new workbook as a report.[Example, in “File1” sheet, name “.sys_cp_param.setup_access.sw_emc” is in offset 0x0f (i.e. Row 26), However, in “File2” sheet, this will shift in offset 0x19 (i.e. Row35)]. Actually, I have written the marco in this file called “CompareSheets”. It will show any differences in yellow color. However, this marco is based on the row to row comparison (i.e.Fixed comparison). If any offset is changed, the result will be wrong after the changed offset.
I know my English is not good so that you may not understand my meanings. Please try to see the attachments and report will be attached in next post.
Thanks
I offer my apology if this question has been presented before, but here is my issue!
In the attached file, it has 2 sheets which are “File2” and “File1” for comparison. Since the “Name” in column E is unique, I would to compare the 2 sheets base on “Name” and then output the difference to a new workbook as a report.[Example, in “File1” sheet, name “.sys_cp_param.setup_access.sw_emc” is in offset 0x0f (i.e. Row 26), However, in “File2” sheet, this will shift in offset 0x19 (i.e. Row35)]. Actually, I have written the marco in this file called “CompareSheets”. It will show any differences in yellow color. However, this marco is based on the row to row comparison (i.e.Fixed comparison). If any offset is changed, the result will be wrong after the changed offset.
I know my English is not good so that you may not understand my meanings. Please try to see the attachments and report will be attached in next post.
Thanks