Is it possible to use multiple tabs in a workbook as one data sour

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michelle @ BMA - 09 Nov 2007 03:25 GMT

I want to create a merge, but the data is within 5 different tabs of my Excel
document. If you can't choose more than one worksheet, then what is the best
way to pull my data from the spreadsheet???

I can't believe there's no way to do this. I tried to learn pivotreport,
but it's not the type of report I need.

I have a spreadsheet containing multiple worksheets. Each worksheet contains
different info. for the same 73 centers. I now need to print out the data
for each center individually & would like to condense the info. to a minimal
amount of pages (3-4).

Reply to this Message

Doug Robbins - Word MVP - 09 Nov 2007 05:58 GMT

Mail merge can only use a single flat file as a data source. As a result,
you would need to link the required information from each of the sheets onto
a single sheet.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I want to create a merge, but the data is within 5 different tabs of my
>Excel
[quoted text clipped - 11 lines]
> minimal
> amount of pages (3-4).

Reply to this Message