Help finding changes made
 

Hello,

I have a task of recording updates made to a spreadsheet
which details various table names, attribute names and
desriptions of a databases.

There are the following column headings to the spreadsheet:

Table name
Attribute name
Description (of Attribute)

For each table, there are multiple attributes. So an entry
looks like follows:

Table Name Attribute Description
---------- --------- -----------
Table1 Name Users name
Table1 Age Users age
Table1 Tel Users telephone

etc. etc.

Now, what i would like to do is compare the data from one
worksheet with another (new) one. Each worksheet has the
same column headings, and when compared, I want the
changes made to the new sheet, to be recorded. For
example, if an row with a new attribute has been added, or
the text in a cell for the desription column has been
edited.

I would like to do this all in Excel, if possible. Maybe a
macro would do it.

I appreciate any help. Thanks in advance!

Jean