Forum Discussion
How to hide data entries by different users in a shared excel sheet
Hi is it possible, to hide data entries in a specific column so that different users without permission can't view it. I.e we would like to create a booking sheet for the different agencies we w...
The only way I can see this work safely is to set up individual copies of this file. One for each agency with just that agencies data. Then you share each file with the appropriate agency.
To get an overview of all agencies, create a new file which pulls in the data from the agency files using Data, Get Data, From File, From Folder.
To get an overview of all agencies, create a new file which pulls in the data from the agency files using Data, Get Data, From File, From Folder.