combining text from separate excel spreadsheets into one spreadshe

[Wayne]

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!,

 

[Arvi Laanemets]

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).