Create PDF of a worksheet based on selected criteria

[tomwhi]

Hi Team,

Once again, I would really appricate your help!

Background:
I am creating a workbook - where the user selects difference criteria (slicers), which specifies which worksheet is relevent (out of 26 different options).

The user then inputs some varible which in turns updates the selected worksheet.

Problem:
Where I need help is the last stage. I want the user to be able to press a button and convert the specifed worksheet into a PDF (the worksheet name will be populate cell A9 of the 'Control Center' worksheet via a formula)

I hope I have provided enough information. Just ask if I need to clarify anything.

THANK YOU FOR YOUR HELP!
Tom

 

[tomwhi]

Any help would be appricatd thanks. I would love to find this proof of concept in the next hour

THANKS!!

 

[tomwhi]

Corrections
*Appriciate*
*Finish*