Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to Merge 2 documents in Excel
Hello, I have a document containing information regarding new customers
and their purchases. Such as total of invoices and FSA's. I also have the same information regarding total customers. I want to put these two documents to join together at the FSA's where possible, but the new customer information to join alongside the total customer information. Here is generally what the totals sheet currently looks like. FSA Total Sales Total Customer Count L3R 6000 5 And so on. This the new customer sheet. FSA New Cus. Sales New Customers L3R 3000 3 And I need it to look like this by the FSA's joining together. FSA Total Sales Total Cust. Count New Cust.Sales New Cust. Count L3R 6000 5 3000 3 My database has like 10000 orders so I would love to be able to throw these together so that the Data does not have to be on two pages, and it is easily read. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to Merge 2 documents in Excel
Have you tried the 'VLOOKUP' Function? Use this function on your 'Total
Customers' sheet and 'lookup' the data you need from your 'New Customer' sheet. -- T Tipsy "Rev" wrote: Hello, I have a document containing information regarding new customers and their purchases. Such as total of invoices and FSA's. I also have the same information regarding total customers. I want to put these two documents to join together at the FSA's where possible, but the new customer information to join alongside the total customer information. Here is generally what the totals sheet currently looks like. FSA Total Sales Total Customer Count L3R 6000 5 And so on. This the new customer sheet. FSA New Cus. Sales New Customers L3R 3000 3 And I need it to look like this by the FSA's joining together. FSA Total Sales Total Cust. Count New Cust.Sales New Cust. Count L3R 6000 5 3000 3 My database has like 10000 orders so I would love to be able to throw these together so that the Data does not have to be on two pages, and it is easily read. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I import data from excel to do a mail merge in word? | Excel Discussion (Misc queries) | |||
My Documents include Excel & Word | New Users to Excel | |||
merge two excel documents | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Trying to merge two excel worksheets | Excel Discussion (Misc queries) |