I am trying to Export 4 sheets to 1 PDF however i only want selected data on each sheet.
I have tried copying everything into one sheet however they have different column widths so this is not a viable option.
I have also tried the following code that works to a point...
On selecting all the sheets it appears to use the range on the last selected sheet for all 4 selected sheets rather than adhering to the previously selected ranges. this causes an issue due to one of the sheets potentially needing more than 1 page depending on the data shown in a pivot table.
I am unable to share the file due to the nature of its contents however i have shared the VBA code i have so far below.
Any help will be appreciated
Bookmarks