HELP Compare two tables MACRO

  • Thread starter Thread starter Les Wegg
  • Start date Start date
L

Les Wegg

HELP - Does anyone have some code to compare two shts (TABLE) from EXCEL.

The table may have 2000 rows with criteria that may have changed in the
columns (10 off). The criteria may have been added, deleted or changed.

I'd preferable like a column adding denoting A, D or C against the Row as
appropriate.

Les.
 
Les

Are you using Access to compare the Excel Tables?

If not then your question would probably be better in an Excel Discussion
Group.

Having said that or if you are using Access I might be able to help if you
can give me a bit more info.

1. Are the two sheets in separate Workbooks?
2. Does one of the sheets always contain all the Base Data (i.e. it never
has anything deleted, added or changed)?
3. Are the rows in each sheet uniquely indexed?

Let me know.

Andy W
 
Back
Top