I have data being copied and pasted to column A then it will automatically put a timestamp (START) to column B. After an employee is done checking the data, he/she will select a status in column C the column D will have another timestamp (the END time). Column E will show the duration, or minutes the employee took to finish checking the data.
I need cells A2:A250 to be locked or protected until after the duration is showing in column E. The employee can only paste another data in A2 after the data in A1 was completely processed (where Start, End and Duration timestamp is present).
I hope someone here can help me with the formula or conditional formatting maybe…to do this. As much as possible not macro because I’m not really familiar with macro.