Data that has been added/changed/deleted between two worksheets

Hi all,

This is my first post. Anyone would know how I could compare 2 worksheets?

I have about 10 columns and 3,000 lines of data.

I need to know the data that was changed, deleted or added in worksheet A vs worksheet B.

Thank you in advance for you help.
Frank

Hi

Are any of the 10 columns (or a combination of columns) a unique key that can be used across both sheets?

If not then what are you using to compare them?

Example file would help clear things up.

rylo

Hi,

I have attached the template with the title of each column. The PRI column is the closest column for the unique key but unfortunately, I have duplication of PRI in the column. The application Diff Doc from Softinterface is doing what I need but I am wondering if an addon in excel or formulas could do the same.

Book1.xls

Hi

OK, you have some column headings. But how about some data, and some comments on what you are doing with that data to give us some idea what you are talking about.

rylo