Hi,
I've got a 2-page dashboard report that I want to be able to multiple versions of, in the same PDF. By 'versions' I mean with changed values based on user selection from a drop-down list.
I think I know how make a button that runs a macro recorded to save the set print area to generate a PDF, but what I'd really like to have happen is that the user can save - in a single PDF - all the versions of the report, as if she had selected them one-by one from the drop-down list, and saved them one at a time.
It occurred to me that one solution would be to have multiple versions of the report in hidden rows below the one the user interacts with, each one populated based on the next item on the list, but that didn't sound very efficient: the report covers a lot of cells (E9:W137, with a page break at row 71) and there is lots of complex formatting, and given the number of versions is variable, I don't think it will work.
Is the best approach to have Excel somehow cycle through the items on the list?
I looked at the similar pivot table question posted here, but couldn't work out how to adapt the solution.
In case it helps, or is otherwise significant, the list (and selection in cell B4) is from a variable list of 30 or so items, defined with named range 'dd_List', who's source is =tbl_1[Full Name & UPN]. That Table is in turn refreshed from a Power Query.
Any advice greatly appreciated.
I think I know how make a button that runs a macro recorded to save the set print area to generate a PDF, but, what I'd really like to have happen that the user can save in a single PDF all the versions of report, as she had selected them one-by one from the drop-down list.
I've got a 2-page dashboard report that I want to be able to multiple versions of, in the same PDF. By 'versions' I mean with changed values based on user selection from a drop-down list.
I think I know how make a button that runs a macro recorded to save the set print area to generate a PDF, but what I'd really like to have happen is that the user can save - in a single PDF - all the versions of the report, as if she had selected them one-by one from the drop-down list, and saved them one at a time.
It occurred to me that one solution would be to have multiple versions of the report in hidden rows below the one the user interacts with, each one populated based on the next item on the list, but that didn't sound very efficient: the report covers a lot of cells (E9:W137, with a page break at row 71) and there is lots of complex formatting, and given the number of versions is variable, I don't think it will work.
Is the best approach to have Excel somehow cycle through the items on the list?
I looked at the similar pivot table question posted here, but couldn't work out how to adapt the solution.
In case it helps, or is otherwise significant, the list (and selection in cell B4) is from a variable list of 30 or so items, defined with named range 'dd_List', who's source is =tbl_1[Full Name & UPN]. That Table is in turn refreshed from a Power Query.
Any advice greatly appreciated.
I think I know how make a button that runs a macro recorded to save the set print area to generate a PDF, but, what I'd really like to have happen that the user can save in a single PDF all the versions of report, as she had selected them one-by one from the drop-down list.