Hi there,
I have a master sheet that other people need to access to read certain rows, but only the information relating to them. How can I restrict what some people see?
The master is in a private folder but I have locations that are available to the other people for some sort of look up of the master. A standard look up wont work as will leave blank rows when its not for their viewing and a filter doesn't update when new information is added to the master.
Data is currently in a table with filters on the titles of each column including a note for who is entitled to see that line of data.
I hope this make some sort of sense .
Suzy
I have a master sheet that other people need to access to read certain rows, but only the information relating to them. How can I restrict what some people see?
The master is in a private folder but I have locations that are available to the other people for some sort of look up of the master. A standard look up wont work as will leave blank rows when its not for their viewing and a filter doesn't update when new information is added to the master.
Data is currently in a table with filters on the titles of each column including a note for who is entitled to see that line of data.
I hope this make some sort of sense .
Suzy