Hi, this is my first post to this forum.

I am compiling a database in Excel and would like some tips on how best to go about it.

Basically, the spreadsheet is as follows:

c. 100 rows of data, each row pertaining to one survey respondant.
The 100 respondants are split between 5 surveyors, who are responsible for inputting the survey responses
The survey consists of 15 Yes/No questions.

What I would like to do is have it so that each surveyor can only change answers for their own respondants- Is there a practical way to do this in Excel?

Also I would like to know if there is any way of entering Yes/No answers in cells that is more convenient/conducive to analysis/presentable?


Thanks you in advance and apologies for being such a novice.