I have a case where I have a formatted spreadsheet with blanks. I need to enter data into various places on this template, from different data sources, as well as add an employee's name. Basically think of it as creating a work schedule based on a calendar tab and another tab with a list of employees and their working hours. Three total tabs, one containing the blank schedule, another containing a calendar and list of shifts available that day, and a third containing a list of employees and their availability.
Is there a way to set this up such that when I open the workbook, it loads the blank templates for each of the tabs so the user can populate the relevant information for availability and open shifts, and then I can link a button to execute the macro that populates the template? I know how to do the button creation, just not sure how to set up the initial data entry in a way that predefines the structure so I can build a repeatable macro to execute and populate the schedule.
Thanks in advance!
Is there a way to set this up such that when I open the workbook, it loads the blank templates for each of the tabs so the user can populate the relevant information for availability and open shifts, and then I can link a button to execute the macro that populates the template? I know how to do the button creation, just not sure how to set up the initial data entry in a way that predefines the structure so I can build a repeatable macro to execute and populate the schedule.
Thanks in advance!