Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining information from 2 Spreadsheets into 1 | Excel Discussion (Misc queries) | |||
Can Excel show changes between two separate spreadsheets? | Excel Worksheet Functions | |||
Combining data from multiple worksheets and separate spreadsheets | Excel Discussion (Misc queries) | |||
Separate Spreadsheets | Excel Worksheet Functions | |||
open multiple excel spreadsheets in separate windows by default | Setting up and Configuration of Excel |