Individual User passwords that only show their results

BryanC72

New Member
Joined
Feb 18, 2018
Messages
5
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.




1588158519677.png



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
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Watch MrExcel Video

Forum statistics

Threads
1,127,594
Messages
5,625,693
Members
416,127
Latest member
MALEPINZON

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top