Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding data within a worksheet made up of links | Excel Discussion (Misc queries) | |||
can this be made smaller? | Excel Discussion (Misc queries) | |||
Can this be made smaller? | Excel Discussion (Misc queries) | |||
save changes when no changes made | Excel Discussion (Misc queries) | |||
postings not being made | Excel Discussion (Misc queries) |