This is the Macro code, shortened in length. I need a code that separates the save as PDF codes, and would select another name from a drop down.
Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+q
'
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _...
I am working on an excel sheet that runs a macro every time you select a name from the drop-down box. The macro pulls the data and fills out the charts and tables correctly. This is where the problem is. I need to run a macro to select a different name from the drop box, then save as PDF. I can...