Hello Everyone,
Just a question: I had a project and had a few data entry clerks entering data on my spreadsheet—only to find out they have been "stealing" someone else's entries by changing the captured row to their names.
So I was thinking, is it possible if someone captures in a cell and they move off that cell? Can that cell lock, and if we need to make changes, a password is used to unlock that cell only then it can be locked again?
And I remember before we could have multiple people capturing on one Excel spreadsheet—can this be done again? If so, please advise how I can do this.
or if someone can give me advise as to how I can set up the spreadsheet so that people dont steal lines and capture at the same time?
Thanking you in advance
Just a question: I had a project and had a few data entry clerks entering data on my spreadsheet—only to find out they have been "stealing" someone else's entries by changing the captured row to their names.
So I was thinking, is it possible if someone captures in a cell and they move off that cell? Can that cell lock, and if we need to make changes, a password is used to unlock that cell only then it can be locked again?
And I remember before we could have multiple people capturing on one Excel spreadsheet—can this be done again? If so, please advise how I can do this.
or if someone can give me advise as to how I can set up the spreadsheet so that people dont steal lines and capture at the same time?
Thanking you in advance