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" <(E-Mail Removed)> wrote in message
news:726A36B5-AD0E-4906-8EC7-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:136DB7F7-9646-42E2-820E-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
>> >> news:9AE377D9-A433-4D2C-A52E-(E-Mail Removed)...
>> >> >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
>> >>
>> >>
>> >>
>>
>>
>>
|
Similar Threads
