comparing contents of worksheets

  • Thread starter Thread starter Papa Jonah
  • Start date Start date
P

Papa Jonah

I need to write a macro that will allow me to compare to worksheets to
identify what has been added, deleted, or otherwise edited from one to the
other.
I know how to program the formatting issues to make sure the columns are
consistent etc. The two worksheets will have a record number in column A.
What I need to do is check each column for a given record number to see if
there are differences.

Any ideas would be greatly appreciated.
TIA
Papa J
 
Papa J,

Reply to me privately (take out the spaces, change the dot to .) and I will send you my add-in that
will add a "Compare WorkSheets..." utility to your Tools menu.

HTH,
Bernie
MS Excel MVP
 
Bernie,
Take the spaces out of what?
I'm not sure where this email is that I should respond to. If it helps you
can email me at adullam04-bd at yahoo dot com
 
Thanks.

I want to make sure I understand what the add on does. It seems to
"physically" open both sheets side by side (or above one another) so that I
can simultaneously scroll through them.

However, I need to be able to have a macro compare them and highlight the
things that have changed from one version to the next. For example, I need
the macro to look at "record" 2007-5690 (the contents of a cell in column A,
and compare the data in each cell in that row with the corresponding cells of
the other worksheet to see if dates, names, etc have changed.

Maybe yours does that already and I'm not doing it right.

Thanks,
Papa J
 
Papa Jonah,

It creates a third sheet named "Edits Made" which highlights the differences between the two
selected sheets.

The version that I sent you requires that both sheets be in the same workbook. Rename one if
necessary.

HTH,
Bernie
MS Excel MVP
 
Papa Jonah,

Send me the workbook with the two sheets, and I will see why my code is failing you. Also, let me
know what column has the key values.

HTH,
Bernie
MS Excel MVP
 

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

Updating Cells after comparing two worksheets 4
Excel Challenge: Compare multiple worksheets macro 18
Advanced compare of two worksheets 2
Compare dates 2
Compare two worksheets in the same workbook and highlight difference 7
comparing two columns in vba 2
Compare worksheets to copy and paste data based on matching criter 1
comparing rows 3

Back
Top