I am looking for a code that will print multiple sheets and combine into pdf based on a cell values on "header" page.
The name of the combined pdf should be what is in cell a1 on 'HEADERPAGE" eg:
random stuff pricing today.PDF
there should be no location set as this will change so a 'Saveas' type option is best.
hope this makes sense.
Please see attached file
Your labels are irregularly spaced from the count boxes, which complicates matters. I moved them so they would all be the same.
Also the labels must exactly match the sheet names so I renamed sheet Apple to Apples.
I have no idea what you mean by this. There is no SaveAs option in VBA for exporting PDF files.there should be no location set as this will change so a 'Saveas' type option is best.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Re: Print multiple pages based on cell value to pdf
Wow! thank you 6StringJazzer that is spot on
Re: Print multiple pages based on cell value to pdf
oh no it has stopped working now that i have added sheets.
please can you advise on what's wrong here?
i am so lost.
Last edited by lpratt; 10-31-2021 at 06:18 PM.
Here is what I said:
You moved them back again. So it won't work.Your labels are irregularly spaced from the count boxes, which complicates matters. I moved them so they would all be the same.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks