Hi

I have a spreadsheet that has to be password protected.

I want to hide all of the data, but allow 10 users to be able to access only the rows of the sheet that apply to their department. They should not be able to see anyone else's.

So for example, when they click to view this sheet,it offers them a password (unique to themselves) and then if they input it correctly only shows perhaps A10 to A15, or particular rows A5, or A2.

In other words the passwords unlocks on the data that is valid to them

Is this possible?