Hi there,
I have built a rostering tool, and am looking to add the functionality of a macro that helps to add new employees.
I propose the following but am open to any solution - especially if it can be accomplished in a simpler way.
I have a sheet ('master') that is the master list of employees, all of which are in column A starting in row 3.
There are seven other sheets for each day of the week - 'Mon', Tue', 'Wed' etc.
The names of employees in the days of the week sheets start in B3.
The challenge:
I would like to be able to call a macro using a 'new employee' button in the 'master' sheet, which then presents the user with a pop up that asks them for their first and last name (in separate text boxes).
The user would then be able to click a 'add employee' button within the userform, and then the new employee is added to each of the days of the week sheets as well as the master sheet.
Note 1: employees are in alphabetical order so the macro would need to insert the new row based on the surname entered into the textbox.
Note 2: The day of week sheets are locked and password protected, so when adding a new employee the sheet would need to be unlocked, name added, then locked again.
I have built a rostering tool, and am looking to add the functionality of a macro that helps to add new employees.
I propose the following but am open to any solution - especially if it can be accomplished in a simpler way.
I have a sheet ('master') that is the master list of employees, all of which are in column A starting in row 3.
There are seven other sheets for each day of the week - 'Mon', Tue', 'Wed' etc.
The names of employees in the days of the week sheets start in B3.
The challenge:
I would like to be able to call a macro using a 'new employee' button in the 'master' sheet, which then presents the user with a pop up that asks them for their first and last name (in separate text boxes).
The user would then be able to click a 'add employee' button within the userform, and then the new employee is added to each of the days of the week sheets as well as the master sheet.
Note 1: employees are in alphabetical order so the macro would need to insert the new row based on the surname entered into the textbox.
Note 2: The day of week sheets are locked and password protected, so when adding a new employee the sheet would need to be unlocked, name added, then locked again.
