HELP Compare two tables MACRO

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.
 
A

Andy Williams

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Comparing two columns 0
"Compile error in table level validation expression " after format 0
Macro for comparing columns and highlighting matching/differences 13
Table Preferred width is changed when pasting 1
Construct table from selected rows 4
Need To Compare Two Worksheets, Update Current Records And Insert New 1
Comparing two columns and returning value from another column 1

Top