WOT: Excel Question - sci.electronics.design

Message from discussion WOT: Excel Question

Michael A. Terrell

View profile

More options Aug 19 2008, 8:04 pm

Newsgroups: sci.electronics.design

From: "Michael A. Terrell" <mike.terr...@earthlink.net>

Date: Tue, 19 Aug 2008 15:04:32 -0400

Local: Tues, Aug 19 2008 8:04 pm

Subject: Re: WOT: Excel Question

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

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

If it is simple data, I would export both to text files, then copy
and past them into a new file, then create a new woorksheet and import
the file. The only downside is the programs usually lose the header
data for each column. Just make sure all the columns are in the same
order before you export, or the data will be in the wrong columns for
some entries.

I have exported a database to text, then used search and replace to
convert the data into HTML. Then I paste the new HTML information into
a blank table in the HTML document. It saved me days of data entry, and
the whole process took less than 15 minutes.

--
http://improve-usenet.org/index.html

aioe.org, Goggle Groups, and Web TV users must request to be white
listed, or I will not see your messages.

If you have broadband, your ISP may have a NNTP news server included in
your account: http://www.usenettools.net/ISP.htm

There are two kinds of people on this earth:
The crazy, and the insane.
The first sign of insanity is denying that you're crazy.

Reply to author Forward