comparing contents of worksheets
 

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

comparing contents of worksheets
 

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


"Papa Jonah" wrote in message
...
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

comparing contents of worksheets
 

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

"Bernie Deitrick" wrote:

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


"Papa Jonah" wrote in message
...
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

comparing contents of worksheets
 

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



"Bernie Deitrick" wrote:

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


"Papa Jonah" wrote in message
...
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

comparing contents of worksheets
 

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" wrote in message
...
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



"Bernie Deitrick" wrote:

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


"Papa Jonah" wrote in message
...
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

comparing contents of worksheets
 

That would be a great answer to my question - but I don't see the third sheet.

PJ

"Bernie Deitrick" wrote:

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" wrote in message
...
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



"Bernie Deitrick" wrote:

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


"Papa Jonah" wrote in message
...
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

comparing contents of worksheets
 

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


"Papa Jonah" wrote in message
...
That would be a great answer to my question - but I don't see the third sheet.

PJ

"Bernie Deitrick" wrote:

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" wrote in message
...
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



"Bernie Deitrick" wrote:

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


"Papa Jonah" wrote in message
...
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