Hello, I need to learn VBA code to do the following when a button (or multiple buttons) are clicked:
1) Save the excel file as a PDF
2) Allow user to browse for save location
3) Name that PDF from a different sheet using multiple cells
I have attached a sample file that a user will input data for multiple categories. For each category there is a corresponding code name that has to be included in the file name. The file name will not be the name of the data sheet, it will be the name of either Template A's saved file or Template B's saved file. There are only 2 options for "Type", Type A and Type B and that is what determines which template gets named.
This will help me SO MUCH I hope someone can help me please. Thanks!
Bookmarks