save worksheet as pdf with a file name from cell content

[enemy_zone]

hi guys,

I need to save excel worksheet as pdf, with file name from cell E20 (drop list). cell E20 contains names that already write in worksheet 'input'. (file link)


so when I click 'print report button', I need to save it as pdf with file name from cell E20 content .
can you help me?

 

[Trevor G]

Record a macro to do this it will give you the code you need.