Locking a row after data entry

Mathew599

New Member
Joined
Nov 13, 2018
Messages
2
I am creating this spreadsheet for work purposes and i need to allow staff to enter customer details, name, order no, address etc.
However i would like for after each customers data enter for that row to be locked.
So ideally i would like after each entry for staff member to initial the entry and for that row to be locked, allowing them to continue on the next row with a new details?

I have managed to get the worksheet to lock each cell after data entry using worksheet protect and password, however the issue is with typos i keep having to unlock the worksheet for them to continue.

Help would be appreciated
 

Forum statistics

Threads
1,085,577
Messages
5,384,551
Members
401,908
Latest member
shaanprakash

Some videos you may like

This Week's Hot Topics

Top