>On Aug 19, 12:02?pm, Jim Thompson <To-Email-Use-The-Envelope-I...@My-
>Web-Site.com> wrote:
>> The crazy Girl Scouts are at it again... merged 3 neighborhoods into
>> one...

>> But created two registrars, each to handle half the troops.

>> So we have two worksheets that need to merged into a single listing of
>> all the troops.

>> Excel 97... I know, I know, but I'm NOT going to spend an outrageous
>> amount upgrading Micro$hit.

>> Any easy way to do it?

>> Thanks!

>>                                         ...Jim Thompson
[snip SIG]

>I am assuming there's a key field in both Excel files and you want a
>new file that merges both (all) original Excel files whether or not
>there is data overlap (one-to-one, one-to-many, or many-to-many) ?

>Do you have MS Access handy?

>If so, it's a lot easier to do the merge that way.
>Let me know and I'll walk you through it.

>If the two Excel files are layed out identically, there is another
>way, but not as "clean".
>And if the Excel files are identicial, and just contain non-
>overlapping data, it can be as simple as cut and paste between open
>worksheets.

>Can you give more guidance on what you want to do?
>-mpm