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 at http://www.analog-innovations.com | 1962 |
Obama, without aid of teleprompter, "Uh...Uh...Uh...Uh...Uh..."
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
>> 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.
>Can you paste one table under another, then do a data/sort by the name >colummn (Or whatever order you wanted)?
>(My ignorance of girl scout administration may have caused me to >misunderstand your problem here)
Columns like this...
Troop Number Leader Co-leader Number-of-girls
I think you have the right clue... maybe just paste rows in, then sort by troop number?
...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 at http://www.analog-innovations.com | 1962 |
Obama, Questioned about the Presidency, it's "above my pay grade"
>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 at http://www.analog-innovations.com | 1962 |
Obama, Questioned about the Presidency, it's "above my pay grade"
Jim Thompson <To-Email-Use-The-Envelope-I...@My-Web-Site.com> writes: > On Tue, 19 Aug 2008 17:27:32 +0100, John Devereux > <jdREM...@THISdevereux.me.uk> wrote:
Web-Site.com> wrote: > 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.
> ...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 -
That will work just fine, provided there is no data overlap. -- otherwise you'll have duplicate records, and you'll have to delete them by hand after sorting.
If the various original Excel sheets don't have identical columns, you'll also have to cut & paste various selections to get them all lined up with each other (or arrange the column order manually before you cut& paste). Either way, sounds simple enough given your data.
> 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.
On Aug 19, 3:04 pm, "Michael A. Terrell" <mike.terr...@earthlink.net> wrote:
> 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.
Or you could have done it in Excel VBA in about 15 seconds....!! (Suitable for framing...)
Sub getlinks() ' ' GetLinks Macro ' Macro recorded 2/2/2008 by mpm
For Each hl In ActiveSheet.Hyperlinks Cells(hl.Parent.Row, 3).Value = hl.Address Next hl
> On Aug 19, 3:04 pm, "Michael A. Terrell" <mike.terr...@earthlink.net> > wrote:
> > 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.
> Or you could have done it in Excel VBA in about 15 seconds....!! > (Suitable for framing...)
> Sub getlinks() > ' > ' GetLinks Macro > ' Macro recorded 2/2/2008 by mpm
> For Each hl In ActiveSheet.Hyperlinks > Cells(hl.Parent.Row, 3).Value = hl.Address > Next hl
> End Sub
If I had Excel. Some of the files would have to be exported anyway, because they were for 10 year old, or older files. A few are over 25 years old, and in a different disk format for a 8 bit CPU.
All I do is add a blank column on the right of the database, and export it wit tab delimiters.
A quick search & replace to convert the double tabs to </td></tr><tr><td>
A second search and replace converts the single tabs to </td><td>
Then you cut <tr><td> from the end of the bottom line and paste it to the start of the first line. If the exported file is clean, it takes seconds to convert in Wordpad. If there are empty cells, you have to remove the extra </tr><tr> but I avoid that problem by using a dash in any blank cell before it is exported. A third search & replace from <td>-</td> to <td> </td> cleans that up, if you don't want to see the dashes.
I normally use a dash to show the cell is supposed to be empty, and it doesn't cause problems with sorts. My first database was program was written to run on a Commodore 64, and used to track the inventory for my shop. Because of the limited RAM (38 kB), I had to separate it into a couple categories. That program could load another that printed a drawer liner for the old metal framed Akro Mills parts cabinets. You just saved the changes and clicked "Need Drawer Liner?". It also printed labels for boxes by selecting "Need Labels?". It was inspired by another program that was a pain in the ASCII to use. Every task required a different program, and was written to drive only one COmmodore printer. It padded the lines to 80 columns, and didn't use any carriage returns or line feeds, so other printers tried to print the entire database onto a single line. It had no search feature, so you had to scroll through all the parts. Then you had the item number. Next, you had to load the edit module and enter the item number, and so on. I deleted over 80% of the original code and combined similar routines. By the time I finished, the entire program was smaller than the main module of the original. It ran about 20 times faster, and allowed you to use any function at any time. I used that program for almost 15 years, before I moved on to a PC.
> 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.
