I am new to macros and was able to put together a template using this forum that works for now but need some help with making it work on a larger scale.
The workbook is a tool for users that populates employee data and allows them to recommend a salary increase based on certain conditions. Once the user has populated the tool, they click a command button and it emails the active worksheet as a pdf file to a specific mailbox for review.
What I am looking for help on is how to add a macro to the same command button that looks at a specific cell and if it says "Yes" then send the file to the mailbox. If that same cell says "No" then save the workbook to a specific folder location with a specific file name. The file name needs to be equal to a different cell value which is a combination of different cells. (Ex. Employee Name + Type of a change + Date + user Name) so we can identify one request from another during an audit.
All of the current macros are assign to a single click of the command button.
Moderators Note: Please follow Forum Rule #3 and use code tags. Added this time, but please use them in the future…Thanks.