J
Jean
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
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