Google Groups Home
Help | Sign in
sci.electronics.design
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
Message from discussion WOT: Excel Question
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
mpm  
View profile
  More options Aug 19 2008, 6:32 pm
Newsgroups: sci.electronics.design
From: mpm <mpmill...@aol.com>
Date: Tue, 19 Aug 2008 10:32:30 -0700 (PDT)
Local: Tues, Aug 19 2008 6:32 pm
Subject: Re: WOT: Excel Question
Reply to author | Forward | Print | View thread | Show original | Report this message | Find messages by this author
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
> --
> | 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, without aid of teleprompter, "Uh...Uh...Uh...Uh...Uh..."

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


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google