Excel> How do I compile data from multiple workbooks into a single tab? This is a contact list.?

I have contact lists from multiple sources and I need the most efficient way to compile all data into one workbook on a single tab. Please note that some names are duplicated on the different source lists. (I was going to use VLOOKUP, but if the names are duplicated, the information from one source list may overwrite information brought in from another source list.)

When dealing with potentially duplicate keys, the easiest way to deal with it would be to create a new key that you expect to be unique. For example, some combination of your first name, last name, zipcode, and a few other fields. You can then use a VLOOKUP on that new column (that should have unique values only) and create your list that way. In general with databases you need to have a unique id in order to be able to reference data reliably.

Another very easy way to consolidate data that is built into Excel are Pivot Tables. If you can get all of your information into a consistent list format and copy it all onto one sheet, Pivot Tables can give you quick answers for a lot of your questions.

One Note Samba

US Auctions Australian Auctions Austrian Auctions Belgian Auctions Canadian Auctions French Auctions German Auctions Irish Auctions Italian Auctions Dutch Auctions Spanish Auctions Swiss Auctions GB Auctions

Best Match Items Ending First Newly-Listed Items First Price + Shipping: Lowest First Price + Shipping: Highest First

10 Metal Stylus Touch Screen Pen for iPhone 4S 4 4G Ipad 2 Galaxy Tab Tab2 Note $2.99 Time Remaining: 28d 12h 7m Buy It Now for only: $2.99 Buy It Now

Steel Stylus Black + Ball Pen for iPhone iPad Galaxy Note S3 Tab HTC 0278BK $2.99 Time Remaining: 49m Buy It Now for only: $3.50 Buy It Now

Tripod Teleprompter Stand Cradle Holder Mount for iPad Galaxy Tab Note Tablet PC $9.99 Time Remaining: 5d 12h 42m Buy It Now for only: $11.99 Buy It Now

10X Mini Stylus Pen for Apple iPhone 4 3G 3GS 4S iPad iPod Touch Galaxy Tab Note $2.97 Time Remaining: 23d 7h 5m Buy It Now for only: $2.97 Buy It Now

10x Black Stylus Pens for Apple iPhone 4 3GS 4S iPad iPod Touch Galaxy Tab Note $2.75 (5 Bids) Time Remaining: 16h 27m

10x Sliver Stylus Pens for Apple iPhone 4 3GS 4S iPad iPod Touch Galaxy Tab Note $2.99 Time Remaining: 19d 16h 37m Buy It Now for only: $2.99 Buy It Now

DUAL PORT 2x USB CAR CHARGER adapter for GALAXY TAB ace S 2 II s2 note White $8.38 Time Remaining: 1h 29m

1pcs Samsung Galaxy Tab 10 101 Note Stylus Styli Pen Stylet Griffel DAGi P508 $23.99 Time Remaining: 1d 22h 10m Buy It Now for only: $26.99 Buy It Now

Black 360 Rotating Stand Leather Case Cover for Samsung Galaxy Note Tab 7 P6200 $12.59 Time Remaining: 29d 6h 33m Buy It Now for only: $12.59 Buy It Now

1pcs Samsung Galaxy Tab 10 101 Note Stylus Styli Pen Stylet Griffel DAGi P508 $23.99 Time Remaining: 1d 22h 10m Buy It Now for only: $26.99 Buy It Now

5x Mini Stylus Pen for Apple iPhone 4 3G 3GS 4S iPad iPod Touch Galaxy Tab Note $1.97 Time Remaining: 11d 16h 28m Buy It Now for only: $1.97 Buy It Now

1pcs Samsung Galaxy Tab 10 101 Note Stylus Styli Pen Stylet Griffel DAGi P508 $23.99 Time Remaining: 1d 22h 14m Buy It Now for only: $26.99 Buy It Now

1pcs Samsung Galaxy Tab 10 101 Note Stylus Styli Pen Stylet Griffel DAGi P508 $23.99 Time Remaining: 1d 22h 14m Buy It Now for only: $26.99 Buy It Now

6600mAh External Backup Battery for iPhone 3GS 4 4S iPad 2 Galaxy tab Note i9220 $23.71 Time Remaining: 25d 16h 10m Buy It Now for only: $23.71 Buy It Now

ERIC CLAPTONS BEST 24 hits with notes Tab 56 pages 1994 $4.99 Time Remaining: 3d 9h 31m

Micro USB to HDMI MHL Adap Kit Samsung Galaxy SII Note Tab Infuse 4G Epic Nexus $17.99 Time Remaining: 29d 17h 43m Buy It Now for only: $17.99 Buy It Now

guitar tab RAGE AGAINST THE MACHINE authentic transcriptionsnotestablature NEW $13.99 Time Remaining: 22h 52m Buy It Now for only: $15.99 Buy It Now

Samsung Galaxy Tab P7500 Cable P1000 Connector I9100 Protector I9220 Accessory $2.49 Time Remaining: 13d 7h 35m Buy It Now for only: $2.49 Buy It Now

Universal External Battery 5000mA White for iPad 3 iPhone Galaxy Tab Note 0213WH $23.00 Time Remaining: 1d 5h 45m Buy It Now for only: $25.99 Buy It Now

U2 THE JOSHUA TREE U2 RECORDED VERSION W NOTES TAB SONGBOOK $9.99 Time Remaining: 1d 3h 19m Buy It Now for only: $14.99 Buy It Now

8 Colorful Metal Stylus Touch Pen for Samsung Galaxy Tab Note P7510 P7500 I9220 $0.99 Time Remaining: 25d 22h 57m Buy It Now for only: $0.99 Buy It Now

LOT of 5 70 total AVERY Note TabS for FILE FOLDERS binders ECT OFFICE SUPPLIES $4.99 Time Remaining: 2d 1h 19m Buy It Now for only: $7.99 Buy It Now

WENGER SWISSGEAR SA9726 Shoulder Messenger Bag Fit iPad 2 Galaxy Tab Note 101 $42.90 Time Remaining: 11d 11h 12m Buy It Now for only: $42.90 Buy It Now

NIP Pink Sticky Notes Tabs $1.99 Time Remaining: 1d 23h 20m Buy It Now for only: $4.99 Buy It Now

NEW DUAL PORT 2x USB CAR CHARGER adapter for GALAXY TAB ace S 2 II s2 note $8.88 Time Remaining: 22h 56m

Tripod Teleprompter Stand Cradle Holder Mount for iPad Galaxy Tab Note Tablet PC $10.99 Time Remaining: 23d 6h 57m Buy It Now for only: $10.99 Buy It Now

10x Black Stylus Pens for Apple iPhone 4 3GS 4S iPad iPod Touch Galaxy Tab Note $1.25 (5 Bids) Time Remaining: 16h 39m

1980S ROCK Easy Guitar with Notes Tab Music Song Book $12.99 Time Remaining: 29d 12h 12m Buy It Now for only: $12.99 Buy It Now

Magnetic Office Notepad coordinating sticky notes tabs magnet rainbow multi LOT $6.99 Time Remaining: 1d 16h 33m Buy It Now for only: $9.99 Buy It Now

1pcs Samsung Galaxy Tab 10 101 Note Stylus Styli Pen Stylet Griffel DAGi P508 $23.99 Time Remaining: 6d 10h 39m Buy It Now for only: $26.99 Buy It Now

5 PCS Pad Pen Stylus For Samsung Galaxy Note P7510 P1000 Tab S2 SII i9100 9220 $2.99 Time Remaining: 28d 13h 53m Buy It Now for only: $2.99 Buy It Now

1pcs Samsung Galaxy Tab 10 101 Note Stylus Styli Pen Stylet Griffel DAGi P508 $23.99 Time Remaining: 6d 10h 39m Buy It Now for only: $26.99 Buy It Now

Post It Type Sticky Memo Notes Index Tabs Desk Box Set $6.01 Time Remaining: 29d 13h 1m Buy It Now for only: $6.01 Buy It Now

1pcs Samsung Galaxy Tab 10 101 Note Stylus Styli Pen Stylet Griffel DAGi P508 $23.99 Time Remaining: 6d 10h 40m Buy It Now for only: $26.99 Buy It Now

Hal Leonard Acoustic Guitar Bible Notes Tabs 2001 Book FREE SHIP $17.25 Time Remaining: 29d 19h 9m Buy It Now for only: $17.25 Buy It Now

1986 GUITAR TECHNIQUES ROCK SCALES GUITAR INTRO TO THE BASICS GRIDS NOTES TAB $0.99 Time Remaining: 5d 22h 12m

Incubus Guitar Songbook Make Yourself Notes Tabs $4.95 Time Remaining: 5d 16h 16m

Colorful Metal Stylus Touch Pen for Samsung Galaxy Tab Note P7510 P7500 I9220 $0.99 Time Remaining: 22d 3h 56m Buy It Now for only: $0.99 Buy It Now

New Stylus Black Touch Screen+Ball Pen for iPhone iPad Galaxy Note S3 Tab 0273BK $3.75 Time Remaining: 7h 12m Buy It Now for only: $4.20 Buy It Now

Mini Bluetooth Headset for samsung Galaxy s ii tab 101 note iphone 3 4 4S PS3 $9.20 Time Remaining: 14d 2h 35m Buy It Now for only: $9.20 Buy It Now

The Songs of Sarah Mclachlan Easy Guitar With Notes Tab 1999 Paperback $4.00 Time Remaining: 4d 1h 9m Buy It Now for only: $5.00 Buy It Now

The Great American Country Songbook Guitar Notes and tabs $9.99 Time Remaining: 4d 22h 54m Buy It Now for only: $15.00 Buy It Now

1980S ROCK EASY GUITAR WITH NOTES TAB MUSIC SONG BOOK $12.99 Time Remaining: 29d 5h 58m Buy It Now for only: $12.99 Buy It Now

10 Metal Stylus Touch Screen Pen for iPhone 4S 4 4G Ipad 2 Galaxy Tab Tab2 Note $2.00 (5 Bids) Time Remaining: 1d 16h 59m

Micro USB to HDMI MHL Adapter f Samsung Galaxy SII Note Tab Infuse 4G Epic Nexus $14.99 Time Remaining: 26d 17h 26m Buy It Now for only: $14.99 Buy It Now

NEW DUAL PORT 2x USB CAR CHARGER adapter for GALAXY TAB ace S 2 II s2 note $8.38 Time Remaining: 1d 1h 23m

Soft Glove Blk Blue for Capacitive iPhone 4S iPad 2 Galaxy S2 Note Tab 0184BB $4.99 Time Remaining: 1d 5h 47m Buy It Now for only: $5.99 Buy It Now

Folk Rock Guitar Bible Notes Tabs 2001 Paperback FREE SHIP $17.50 Time Remaining: 29d 18h 59m Buy It Now for only: $17.50 Buy It Now

Capacitive Screen Glove for iPhone 4S iPad 2 Galaxy S2 Note Tab Yellow 0170YW $4.99 Time Remaining: 1d 5h 45m Buy It Now for only: $5.99 Buy It Now

Hal Leonard Acoustic Hits Guitar Bible Notes Tabs FREE SHIP $16.45 Time Remaining: 29d 19h 2m Buy It Now for only: $16.45 Buy It Now

For iPhone iPad 3 Galaxy Note Tab Universal External Battery 5000mA Black 0213BK $23.00 Time Remaining: 1d 5h 46m Buy It Now for only: $25.99 Buy It Now

Post-it Note Info Tab Labels, 3-3/8 Inches x 2 Inches, 25 per Color, Coral, Yellow (2200-RY) Sale Price: $4.51   Eligible for free shipping! Availability: Usually ships in 24 hours See Reviews For This Product Description Organize binders, file folders and work-in-process folders easily and without damage with NEW Post-it Note Tabs. Large, lined surface area for detailed tabbing and indexing. Sticks securely, removes cleanly...

Avery Write-On Tabs, 1.75 Inches, 48 Tabs (16143) Sale Price: $6.49   Eligible for free shipping! Availability: Usually ships in 24 hours See Reviews For This Product Description Make sure you're always in the right spot. Easily find your place in books, reports, catalogs and more with the help of these Write-On Tabs. Attach brightly colored self-stick tabs to help you flip back to specific pages...

Post-it Note Tab, 3.37 x 2.75 Inch, Green and Blue (2200-GB) Sale Price: $4.59   Eligible for free shipping! Availability: Usually ships in 24 hours See Reviews For This Product Description Organize binders, file folders and work-in-process folders easily and without damage with NEW Post-it Note Tabs. Large, lined surface area for detailed tabbing and indexing. Sticks securely, removes cleanly...

DURAGADGET Genuine BLACK Leather Protective Case With Stand For Samsung Galaxy TAB (P1000) List Price: $44.99 Sale Price: $26.99 You save: $18.00 (40%)   Eligible for free shipping! Availability: Usually ships in 24 hours See Reviews For This Product Description DURAGADGETS new Samsung Galaxy Tab case gives you the confidence to get out and use your tablet. The strong leather outer is both aesthetically pleasing and tactile to the touch while the PU Leather inner frame protects your device and keeps it in place...

Eric Clapton - From the Album Eric Clapton Unplugged (Catalog No. 702086) List Price: $10.95 Sale Price: $9.19 You save: $1.76 (16%)   Eligible for free shipping! Availability: Usually ships in 24 hours See Reviews For This Product Description Matching folio to his best-selling acoustic album. 14 songs, including: Tears in Heaven * Nobody Knows You When You're Down and Out * Layla * Alberta * Old Love * and more.

Guitar Scale Reference - Learn All the Notes of the Neck - With Tablature (Scales / Tab) List Price: $2.99 See Reviews For This Product Description With this low priced, well formatted reference, you can use your Kindle as a fast easy reminder when practicing your guitar scales. Using both diagrams of the neck and tablature, you have all you need to learn the placement of all the notes on the guitar...

Post-it(R) Durable Index Tabs, 1 Inch, Ideal For Binders And File Folders, Assorted Colors, 66 per Dispenser (686-RYB) Sale Price: $6.49   Eligible for free shipping! Availability: Usually ships in 24 hours See Reviews For This Product Description For easy indexing and labeling. Large writing surface with color bars for color-coding. File Insert/Tab Type: N/A; Global Product Type: File Inserts/Tabs; Tab Cut: N/A; Color(s): Blue; Red; Yellow.

The Great American Country Songbook - Easy Guitar with Notes & Tab Sale Price: $12.95   Eligible for free shipping! Availability: Usually ships in 2-3 business days See Reviews For This Product Description Easy arrangements with tab for 50 all-American country classics, including: Act Naturally - All My Ex's Live in Texas - Boot Scootin' Boogie - Crazy - Elvira - Faded Love - Folsom Prison Blues - For the Good Times - Friends in Low Places - Georgia on My Mind - Hey, Good Lookin' - King of the Road - Lucille - Rocky Top - Sixteen Tons - Take Me Home, Country Roads - There's a Tear in My Beer - You're the Reason God Made Oklahoma - Your Cheatin' Heart - and more.

Samsung Galaxy Tab (T-Mobile) List Price: $749.99 Sale Price: $629.99 You save: $120.00 (16%)   Eligible for free shipping! Availability: Usually ships in 24 hours See Reviews For This Product Description Enjoy a rich, brilliant viewing experience wherever you roam with the Android-powered, 3G-enabled Samsung Galaxy Tab mobile tablet for T-Mobile--a powerful, entertainment device ideal for home or on the go...

GraniteCases Samsung Galaxy Tab Genuine Leather Case Folio - Dark Brown List Price: $39.99 Sale Price: $34.95 You save: $5.04 (13%)   Eligible for free shipping! Availability: Usually ships in 24 hours See Reviews For This Product Description Beautiful genuine leather case for the new Samsung GALAXY Tab. This case is made of high quality genuine leather. You can easily access the Tab's navigation features and power switch while still enjoying a perfect fit in your hands...