merge with excel question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cowtoon - 06 Dec 2004 17:57 GMT

I have all of my data for my merge in an excel spreadsheet. For good
reasons, the spreadsheets has the information in several worksheets (but all
in one file).

Is there a way to do a merge that will include all of the worksheets? I
have to do toooooo many merges to merge all of the data, otherwise. I don't
usually merge all of the worksheets at a time.

Can someone help with this. Thanks. Diana

Reply to this Message

Doug Robbins - 07 Dec 2004 10:51 GMT

Word can only use a single "flat file" as the data source. If for some
other reason, you need to keep the separate worksheets, add another
worksheet to the file on which you have references to each of the cells in
the individual worksheets so that on that new worksheet ALL of the data is
displayed.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I have all of my data for my merge in an excel spreadsheet. For good
> reasons, the spreadsheets has the information in several worksheets (but
[quoted text clipped - 7 lines]
>
> Can someone help with this. Thanks. Diana

Reply to this Message