Sep 12 2021 04:37 AM
Hi
I have an excel worksheet with different suppliers and their relevant inputs which needs to be keyed in by each and every supplier every week. I need to make sure that Supplier A can view only his/her relevant details. when supplier B opens up the same worksheet, I need the restrict him to view only his relevant data.
Is there a way to restrict this?
Thanks
Sep 12 2021 09:04 AM
SolutionI don't think that's possible. More feasible solution of each supplier works with its own file and you combine them in one with Power Query or like.
Sep 12 2021 09:04 AM
SolutionI don't think that's possible. More feasible solution of each supplier works with its own file and you combine them in one with Power Query or like.