I am creating a spreadsheet that multiple users will input data, tracking certain tasks. Example
name S shift E shift task start end total
Joe Shmo 12:00 10:30 task1 1:15 1:47 0:32
The name will be selected from a drop down selection. Once the name has been selected the shift start and end time will be inserted from a lookup table. The user then selects the task from another drop down, enters the start and end time and the total is displayed. I want to create a Y/N input cell that if selected Y, the same name is inserted in the next line (reducing data input) the user when then just have to add the task and times. If N is selected the a popup would remind the user to save the data. How can I do this?
name S shift E shift task start end total
Joe Shmo 12:00 10:30 task1 1:15 1:47 0:32
The name will be selected from a drop down selection. Once the name has been selected the shift start and end time will be inserted from a lookup table. The user then selects the task from another drop down, enters the start and end time and the total is displayed. I want to create a Y/N input cell that if selected Y, the same name is inserted in the next line (reducing data input) the user when then just have to add the task and times. If N is selected the a popup would remind the user to save the data. How can I do this?