HOW TO MERGE TWO TABLES
Support,
I'm trying to find a way to merge to worksheets into one. One of the worksheets containts a list of customers including their Cust #, Add, City, St, Zip, Phone. The other worksheet includes the sales for the customers in the first list. However, not all of the customers will have sales so the data will not match up when copied and pasted together. This leaves me to manually cut and paste each row to match up the customer numbers with sales and the customer on the address list. (see bleow for an exmaple) Cust #1 - Sales - Cust #2 - Add - City - St - Zip - Phone 1 10.00 1 sdf sdfs pa 123 123-456-7891 2 11.00 3 sdf sdfs pa 123 123-453-7894 3 12.00 5 sdf sdfs pa 123 123-454-7898 4 13.00 6 sdf sdfs pa 123 123-455-7899 5 14.00 7 sdf sdfs pa 123 123-455-7799 As you can see there isn't a match for Cust #2 and 4 from the first column to the second customer column. How can I get the two columns to match up an enter the remaining customers as blanks at the end of the worksheet? Maybe through a Pivot Table but I haven't been able to figure it out. Any thoughts greatly appreciated. -- Thanks, Bill V SBS ROCKS! http://www.oursalon2u.com http://www.raylon.com http://sbsbill.blogspot.com/ |
As long as you have 1 common field (customer number) for both tables you can pull in the data to one table using the VLOOKUP. -- Phillycheese5 ------------------------------------------------------------------------ Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196 View this thread: http://www.excelforum.com/showthread...hreadid=390604 |
All times are GMT +1. The time now is 10:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com