We’ll tell you how this works in the following steps. Now you have to adapt the calculation module in the bottom of the Excel template. You have now created a new drop-down menu that links to your employee list, making the shift allocation process significantly easier. Next, in the “ input message” tab, remove the check next to “show input message when cell is selected.” Do the same with the tick at “ show error alert after invalid data is entered” in the “ error alert” tab.Alternatively, you can enter the source manually. This will now be used as a source for your drop-down menu and will be shown the respective dialog field with the formula, which could look something like this: =$C$35:$C$42. With your mouse, mark your employee list.Now, click on the button next to the dialog box “ source.”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |