I have a spreadsheet that tracks my sales staff projects. One column has a drop down that identifies my 6 sales staff. Currently my sales staff can view their projects and their counterparts projects, sales, loses, etc. They can sort by their name and concentrate on their specific projects. HOWEVER, they can also view their neighbors efforts and comment/complain that somebody else has easier projects, higher revenue earning projects, etc.

QUESTION: My assistant updates this workbook (on the server) daily. Is there a way for her to update this workbook with everybodys information (administrator privilege) BUT assign "view" privileges to each sales person so they can only view their work, not their neighbors?