Excel Problem

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

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

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

...Jim Thompson

"Jim Thompson" wrote in message news: snipped-for-privacy@4ax.com...

That?s a separate MS program.

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

Cheers

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

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.

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

Databases have integrity checking features, spreadsheets do not.

Idiot! That is NOT the question he asked.

Pasted data and existing data still allows for duplicates.

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.

He was incorrect.

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.

AlwaysWrong strikes again.

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

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.

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.

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

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

That excludes dimbulb. 15 of him would still fall short of half a brain.

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.