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
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
