Hi all
Just after some guidance.
I have a report template from which i create up to about 25 pdf pages based on different filters. I have a vba loop which basically creates duplicates of the sheet, applies the next filter and then exports everything at the end to a single pdf.
Just wondering if there's a way to do it without doing all the duplicate sheets?
It may be getting scaled up to circa 500 pages in the near future, which i think at that point will start to cause performance issues in excel.
I know I can just create a load of pdfs then combine them in adobe afterwards, but wondered if there's a way to handle this in excel?
Thank you
Just after some guidance.
I have a report template from which i create up to about 25 pdf pages based on different filters. I have a vba loop which basically creates duplicates of the sheet, applies the next filter and then exports everything at the end to a single pdf.
Just wondering if there's a way to do it without doing all the duplicate sheets?
It may be getting scaled up to circa 500 pages in the near future, which i think at that point will start to cause performance issues in excel.
I know I can just create a load of pdfs then combine them in adobe afterwards, but wondered if there's a way to handle this in excel?
Thank you
