Excel Problem

[Jim Thompson]

Another !@#$%&* Girl Scout related problem...

Excel '97

TWO registrars (my wife and another woman) listing troops and girls on
two _separate_ spreadsheets :-(

Fortunately both sheets have the same formatting of rows and columns.

How does one _easily_ merge both sheets ??

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 | |
| Voice480)460-2350 Fax: Available upon request | Brass Rat |
| E-mail Icon at http://www.analog-innovations.com | 1962 |

I love to cook with wine Sometimes I even put it in the food

 

[PeterD]

Another !@#$%&* Girl Scout related problem...

Excel '97

TWO registrars (my wife and another woman) listing troops and girls on
two _separate_ spreadsheets :-(

Fortunately both sheets have the same formatting of rows and columns.

How does one _easily_ merge both sheets ??

Thanks!

...Jim Thompson

Load both, copy cells from second sheet to clipboard, paste into first
sheet. Sort if you desire.

 

[Jim Thompson]

Load both, copy cells from second sheet to clipboard, paste into first
sheet. Sort if you desire.

That sounds simple enough for even me to handle ;-)

...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 | |
| Voice480)460-2350 Fax: Available upon request | Brass Rat |
| E-mail Icon at http://www.analog-innovations.com | 1962 |

Gourmet Puzzles:

What part of the fish are the "sticks"?

Likewise where are the chicken "fingers" located?

 

[Joerg]

Another !@#$%&* Girl Scout related problem...

Excel '97

TWO registrars (my wife and another woman) listing troops and girls on
two _separate_ spreadsheets :-(

Fortunately both sheets have the same formatting of rows and columns.

How does one _easily_ merge both sheets ??

Guess the copy&paste has worked but just one hint:

Member listing and most of this is much better done in a database
format. Sorting, searching, reporting, all much easier. Plus you can
enter data pretty much willy-nilly and it sorts it into order with the
click of a button. I use MS-Works database for this, comes pre-installed
on most PCs.

 

[Jim Thompson]

Guess the copy&paste has worked but just one hint:

Member listing and most of this is much better done in a database
format. Sorting, searching, reporting, all much easier. Plus you can
enter data pretty much willy-nilly and it sorts it into order with the
click of a button. I use MS-Works database for this, comes pre-installed
on most PCs.

I know, but some jerk in GS land has dictated Excel :-(

...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 | |
| Voice480)460-2350 Fax: Available upon request | Brass Rat |
| E-mail Icon at http://www.analog-innovations.com | 1962 |

Gourmet Puzzles:

What part of the fish are the "sticks"?

Likewise where are the chicken "fingers" located?

 

[Jim Thompson]

Guess the copy&paste has worked but just one hint:

Member listing and most of this is much better done in a database
format. Sorting, searching, reporting, all much easier. Plus you can
enter data pretty much willy-nilly and it sorts it into order with the
click of a button. I use MS-Works database for this, comes pre-installed
on most PCs.

I've got XP-Pro. Can't find MS-works. Where does it hide out?

...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 | |
| Voice480)460-2350 Fax: Available upon request | Brass Rat |
| E-mail Icon at http://www.analog-innovations.com | 1962 |

Gourmet Puzzles:

What part of the fish are the "sticks"?

Likewise where are the chicken "fingers" located?

 

[Martin Riddle]

I've got XP-Pro. Can't find MS-works. Where does it hide out?

That’s a separate MS program.

BTW, SHIFT-CTRL-DownArrow will select all the cells down to the last
row.

Cheers

 

[krw]

I've got XP-Pro. Can't find MS-works. Where does it hide out?

^^^^^^^^
It doesn't.

 

[krw]

That sounds simple enough for even me to handle ;-)

I generally import each list into a separate sheet then do a copy to a
third and manipulate the data there. Just remember the difference
between copy and copy-value. You can also do a Data=>Import from a
CSV, or some such.

 

[FatBytestard]

Another !@#$%&* Girl Scout related problem...

Excel '97

TWO registrars (my wife and another woman) listing troops and girls on
two _separate_ spreadsheets :-(

Fortunately both sheets have the same formatting of rows and columns.

How does one _easily_ merge both sheets ??

Thanks!

...Jim Thompson

Export both to Access database, merge the files, and export out to excel
spreadsheet.

Databases have integrity checking features, spreadsheets do not.

 

[FatBytestard]

Load both, copy cells from second sheet to clipboard, paste into first
sheet. Sort if you desire.

Idiot! That is NOT the question he asked.

Pasted data and existing data still allows for duplicates.

 

[FatBytestard]

I know, but some jerk in GS land has dictated Excel :-(

...Jim Thompson

So you use a database to manage the data, and have it viewable as an
excel spreadsheet. That is one way to beat the dope at his own game.

This is a simple list. You do not really need a database as a "flat
file" method is quite sufficient, which means that excel should be fine
for this simple listing tool.

 

[FatBytestard]

I've got XP-Pro. Can't find MS-works. Where does it hide out?

He was incorrect.

 

[krw]

Unless there are duplicates. If so, expect to spend a fair bit of time
weeding them out.

Nah, that's easy to fix. Sort and compare cells using conditional
formatting to highlight duplicate records.

 

[krw]

Idiot! That is NOT the question he asked.

AlwaysWrong strikes again.

Pasted data and existing data still allows for duplicates.

Easy to solve, for anyone with half a brain, DimBulb.

 

[FatBytestard]

Nah, that's easy to fix. Sort and compare cells using conditional
formatting to highlight duplicate records.

Still a manual culling operation.

Paste both sheets into a simple database... almost ANY simple
database, and it will automatically cull the dupes. Then paste back to
either sheet. Done. No highlighting, no sorting, no examining, no
manual operations at all.


Hell, paste them into abse, or onto a hosting site, and someone will
make the perfect Girl Scout tracking spreadsheet for it.

 

[FatBytestard]

AlwaysWrong strikes again.

We both know he wanted no dupes. That rules you out as we all know
that you are a dupe for someone that really knows what is going on.

Easy to solve,

Some of us know that. Some do not. Regardles of how the data is
stored.

for anyone with half a brain, DimBulb.

Anyone with even close to half a brain would not utilize your method,
idiot. Even if we were only talking about ten records.

 

[Joerg]

I've got XP-Pro. Can't find MS-works. Where does it hide out?

It may not always come pre-loaded with XP-Pro computers. Did come with
nearly all my PCs though. I do not like Version 8.0 much, has a
copy&paste bug that rears its ugly head at times where it just doesn't
want to paste. Not sure how version 9 fares but they all have the
database and that's the only item that matters to me:

http://store.purplus.net/miwo9.html

Usually it's the same with many such products, the older the more
stable. I run all my book-keeping stuff with it. Business records, tax
prep records, parts inventory, billing, all databases.

For example if a client wants to know how many hours I am into their XYZ
project I can tell them within seconds. Click filter, enter project
name, click report -> tada.

 

[Jim Thompson]

[snip]

... I use MS-Works database for this, comes pre-installed
on most PCs.

I've got XP-Pro. Can't find MS-works. Where does it hide out?

It may not always come pre-loaded with XP-Pro computers. Did come with
nearly all my PCs though. I do not like Version 8.0 much, has a
copy&paste bug that rears its ugly head at times where it just doesn't
want to paste. Not sure how version 9 fares but they all have the
database and that's the only item that matters to me:

http://store.purplus.net/miwo9.html

Usually it's the same with many such products, the older the more
stable. I run all my book-keeping stuff with it. Business records, tax
prep records, parts inventory, billing, all databases.

For example if a client wants to know how many hours I am into their XYZ
project I can tell them within seconds. Click filter, enter project
name, click report -> tada.

I use "Responsive Time Logger" for those occasional by-the-hour
projects.

But it looks like "Works" is cheap enough to see how it might work for
GS registration data... the wife informs me that Excel is just what
our local neighborhood is using... NOT cast in stone by the "down-town
empire" ;-)

...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 | |
| Voice480)460-2350 Fax: Available upon request | Brass Rat |
| E-mail Icon at http://www.analog-innovations.com | 1962 |

Gourmet Puzzles:

What part of the fish are the "sticks"?

Likewise where are the chicken "fingers" located?

 

[Jim Thompson]

1. Export both files as .csv.
2. Open both, copy one and past it to the other.
3. Save the new combined .csv file, then import the new file into
Excel.

Aha! Thanks, Michael!

...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 | |
| Voice480)460-2350 Fax: Available upon request | Brass Rat |
| E-mail Icon at http://www.analog-innovations.com | 1962 |

Gourmet Puzzles:

What part of the fish are the "sticks"?

Likewise where are the chicken "fingers" located?