Question about Microsoft Office Standard for PC
Good Morning All, I need to merge two seperate work books, of average 20 columns width Both do/do not hold matching information. EG: Worksheet A Joe Smith Address1 Address2 City Postcode Work Sheet B Joe Smith City E-mail Telephone What I would like to do is create a single merged workbook which has all the fields merged into a single row - without duplication (obviously, I can backtrack and delete manually if necessary) Thank-you
If the First Name and Last name are equal to both work sheets, I will just sort them by First Name and Last name and copy the results into a separate work sheet. If the names are different you will have to use Access: This can be easily done with Access and SQL, just import both work books into different tables to access and use the create query wizard, play with the results until you will get the result you want. Access will also solve the duplicate problem easily. Very important: You will have to use join properties: Read help about join properties and understand how this works... Afterward you can export it back to Excel or use Copy/Paste. If you can't use Access and have only Excel: You will have to use Vlookup on various fields until you will get the result you want. Its a hard work but in the end you will get the same result as access. Let me know what happend Daniel
Posted on Aug 20, 2007
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Oct 08, 2013 | Microsoft Office 2003 Basic Edition...
Jun 15, 2010 | Microsoft Office Excel 2007
Nov 09, 2009 | Microsoft Computers & Internet
May 15, 2009 | Microsoft Office Professional 2007 Full...
May 05, 2009 | Computers & Internet
Mar 11, 2009 | Xerox Phaser 8550DT Thermal Printer
Jan 06, 2009 | Computers & Internet
Dec 24, 2008 | Intuit QuickBooks Pro 2007 Full Version...
Apr 29, 2008 | Microsoft Excel for PC
154 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: