combining text from separate excel spreadsheets into one spreadshe
Hello!,
I will try to be brief. A series of Excel spreadsheets were created inadvertently by a secretary using the save as feature. Each has its own name. Each spreadsheet has duplicate as well as unique text. Is there a method that can easily combine without duplicating these spreadsheets into one harmonious spreadsheet? Any light shed on this is appreciated. Thank you!, -- WCS |
combining text from separate excel spreadsheets into one spreadshe
Hi
It depends on your unique info. When certain info must fill certain gaps between fixed text, then I'll advice to use Word Mail Merge with an Excel table as source file. I.e. you create an Excel table, which has header row in row 1 and where all specific info for a document is collected in single row of table, along with an unique identifier for document. Then in Word, you create a Mail Merge template with this table as a source file, type your fixed text into this template, and insert according fields (Column Headers) from Excel table into template at proper places. Now you can at any time generate any document or set of documents, based on data in Excel table (you can set filter conditions when starting Mail Merge with created template) and direct the output to new Word file (every document starts at new page), directly to printer, or send it as a mail (when you have MS Outlook installed). -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Wayne" wrote in message ... Hello!, I will try to be brief. A series of Excel spreadsheets were created inadvertently by a secretary using the save as feature. Each has its own name. Each spreadsheet has duplicate as well as unique text. Is there a method that can easily combine without duplicating these spreadsheets into one harmonious spreadsheet? Any light shed on this is appreciated. Thank you!, -- WCS |
All times are GMT +1. The time now is 01:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com