drop down list and Locking certain cells

D

Dpman23

I want to create a drop down list of a few names. At the end of th
shift I want to be able to lock a the cells in which they entered i
information (which would be the row of information in which their nam
is entered) after their shift is closed.

Basically I have 60 rows of information and at the end of each row woul
be a drop down list of their names and at the end of the shift I wan
all the rows in which they entered informaton from column B-G to lock.

Any of that possible
 
Top