I am looking for guidance on applying a macro to enhance a working excel file. I am fairly new to using the VBA functionality.
In summary, my file is designed to be a salary questionnaire for business partners. The file will update to show applicable data based on one control drop down option. The rest of of file will update when you change the drop down selection. The drop down is pulling data based on the applicable business partner. I am looking to build a macro to create separate workbooks for all options within the the drop down. For instance, I use option 1 in the drop down and my file updates to produce a separate work book. Then, it moves on to address option 2, the data updates, and produces a separate work book. Have these steps repeat until all 13 options have separate work book excel files.
If anyone could recommend coding guidance or tuturial, it would be greatly appreciated. Please let me know, if you need to clarify my project case.
In summary, my file is designed to be a salary questionnaire for business partners. The file will update to show applicable data based on one control drop down option. The rest of of file will update when you change the drop down selection. The drop down is pulling data based on the applicable business partner. I am looking to build a macro to create separate workbooks for all options within the the drop down. For instance, I use option 1 in the drop down and my file updates to produce a separate work book. Then, it moves on to address option 2, the data updates, and produces a separate work book. Have these steps repeat until all 13 options have separate work book excel files.
If anyone could recommend coding guidance or tuturial, it would be greatly appreciated. Please let me know, if you need to clarify my project case.