> On Tue, 19 Aug 2008 10:32:30 -0700 (PDT), mpm <mpmill...@aol.com>
> wrote:

> >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?

> NO!

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

> I think paste, then sort will work.