Hello,
My colleagues and I have a large database containing information regarding suppliers. I need to share the information that is relevant to each supplier, with that supplier. I can obviously run a report to pull the data out based on 'Supplier' column in our sheet, as there are a large number of suppliers on this sheet I do not want to have to create a new report for each supplier in order to keep their information confidential. Is there a way to run a single report and ensure that from that report Supplier A only has visibility of the information held that relates to them, Whilst Supplier B can only see their information, or do I have to run individual reports?
Thanks,
Stephen