|
In response to
"I'm trying to create an excel file which has a bunch of repeating pages, and send it to a PDF as a bunch of repeating pages."
by
Subversive
|
Are the pages different worksheets? Select all the sheets that you want to include before making the pdf. On one sheet, set a print area that includes
Posted by
zork
Nov 5 '15, 17:33
|
all the pages that you want to print.
And, of course, you can do a combination.
I just made a macro that produces a whole bunch (260+) of Excel files with two sheets each and it also saves each one to a two page pdf. It selects each different option from a dropdown list for each file and then one of two values somewhere else for each of the pages.
|