Is there a way I can have a sheet where multiple users can lock the cells? See reference image:
Excel 1.PNG
I want the titles of the cells (the bolded Date/Time, Volume, Initials, ect.) locked so no one can edit them, but allow users to input the data in the following cells, like the data on 4/26. Then, ideally, the user would lock that row of data with a password so only that user can edit it in the future. The other cells need to remain unlocked so a different user could input new data the following day and then lock it with his/her own password and continue on as such. The key being cells without data in them are unlocked so data can be added each day.
If more explanation is needed, please let me know.
Bookmarks