comparing two sheets and record changes

Hi, I am trying to run a script that will compare two different sheets and write changes on same row, different column.

i.e script will detect contents in sheet1 A5 and sheet2 A5 are different then script will type "old one says ~~, new one says ~~" on column F row 5

This is what I got so far, I did get some help but I wasn't sure how to ellaboard the last "if not" part

Please Login or Register  to view this content.

In attachment, there is one file with the script (one that brings the excel files and one that has the script that I am trying to figure out), and there is one sample file to compare

Hi there,

See if the attached version of your workbook does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.

The code is a bit more efficient than the code you posted because it compares only those rows/columns which contain data values. It will also cope with two worksheets which have different numbers of rows/columns which contain data values.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi Thank you very much for your help it works great and super fast!

now i am also trying to change those code little bit so it can detect when rows are added also

do you have any idea on that?