Hi all,
I have a sheet showing consultants results in a pivot and I'm using 2 slicers for filtering.
I'm trying to achieve a password situation and I'd like each consultant to have their own password to the same sheet but when they enter their unique password, they are only able to see their own data and nobody else's.
Is this something that can be done while using slicers or even multiple passwords on 1 sheets by linking the passwords to specific filter conditions???
For example: Consultant 1 opens the sheet and is asked for their password and then the data filters to show only Consultant 1 data and locks the rest of the data away from view. They would also not be able to use the Name slice to then select another consultant. I can lock that slicer from operation and just leave the posting date slice active when protecting the sheet, which should elevate this problem I think but don't know how to implement the individual password concept.
I would like to hide the other consultants names in the slicer once an individual enters their own password so they can't select anyone else.
I hope I've explained this ok.
Are you able to suggest any solution for this problem please.
Thanks in advance.
Bryan
I have a sheet showing consultants results in a pivot and I'm using 2 slicers for filtering.
I'm trying to achieve a password situation and I'd like each consultant to have their own password to the same sheet but when they enter their unique password, they are only able to see their own data and nobody else's.
Is this something that can be done while using slicers or even multiple passwords on 1 sheets by linking the passwords to specific filter conditions???
For example: Consultant 1 opens the sheet and is asked for their password and then the data filters to show only Consultant 1 data and locks the rest of the data away from view. They would also not be able to use the Name slice to then select another consultant. I can lock that slicer from operation and just leave the posting date slice active when protecting the sheet, which should elevate this problem I think but don't know how to implement the individual password concept.
I would like to hide the other consultants names in the slicer once an individual enters their own password so they can't select anyone else.
I hope I've explained this ok.
Are you able to suggest any solution for this problem please.
Thanks in advance.
Bryan