Hi experts,
Need your help again. I need to do some changes in my file.
First, when the user enters the start & end time with same day with their name, it would become red highlighted & message popped out to change the time to void duplicate (row 10 & 13).
Second, when they click the submit button, all data entered in sheet 1 goes to master sheet in same format & removes the entered data
in sheet 1 but leave the formulas in sheet 1 so that next time when user enters data, it would update itself & append the data in master sheet
on again submitting it.
I have attached the sheet for your reference. please help with the solution
Thanks in advance.
Need your help again. I need to do some changes in my file.
First, when the user enters the start & end time with same day with their name, it would become red highlighted & message popped out to change the time to void duplicate (row 10 & 13).
Second, when they click the submit button, all data entered in sheet 1 goes to master sheet in same format & removes the entered data
in sheet 1 but leave the formulas in sheet 1 so that next time when user enters data, it would update itself & append the data in master sheet
on again submitting it.
I have attached the sheet for your reference. please help with the solution
Thanks in advance.