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

> ...Jim Thompson
> --
> | James E.Thompson, P.E. | mens |
> | Analog Innovations, Inc. | et |
> | Analog/Mixed-Signal ASIC's and Discrete Systems | manus |
> | Phoenix, Arizona 85048 Skype: Contacts Only | |
> | Voice:(480)460-2350 Fax: Available upon request | Brass Rat |
> | E-mail Icon athttp://www.analog-innovations.com| 1962 |

> Obama, Questioned about the Presidency, it's "above my pay grade"- Hide quoted text -

> - Show quoted text -