I'm building a report that uses slicers to select up to 258 different sets of data (3 slicers with mutiple selections each). I am hoping to write a macro to print all possible combinations of data selected via these 3 slicers. Does anyone have a macro that does something similar? Basically need it to run through each slicer selection, and print the displayed data to .pdf.
I'm thinking it will be a lot of true/false statements, and I'm afraid it may crash the workbook to print that many .pdf files.
Anyone have any experience with this big of a print macro?
Thanks!
Josh
I'm thinking it will be a lot of true/false statements, and I'm afraid it may crash the workbook to print that many .pdf files.
Anyone have any experience with this big of a print macro?
Thanks!
Josh