Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
how to import into MS Word ,data from two worksheets from Workbook of MS Excel file ?
I have MS-excel Data with a customer sheet with address details on one sheet & Items bought by a customer on other sheet,by using mail merge I am able to generate a letter for each customer by using customer sheet,I want to include details of items bought(from that items sheet).
sheet1 and sheet2 are linked by customer ID number?
3 Answers
- VBAXLManLv 61 decade agoFavorite Answer
I suggest you having a third worksheet that list the customers and their buying details
Then mail merge it
You might need to use formulas to do so, like VLOOKUP, MATCH, INDEX, IF, COUNTA, etc
use the customerID to grap these info
VBAXLMan
- Anonymous1 decade ago
That would depend on what links sheet1 with sheet2. The same customer name? A customer ID number?
- 5 years ago
It depends on which version of office you are using. MS Office 2007 has a full utility for converting and editing PDF files.
