Forum Discussion
spreadsheet protection
Hi,
Require some help to protect a spreadsheet which will be filtered to individual managers.
I require parts of the sheet to be locked, with other columns open for data input.
7 Managers, each seeing only there respective business units once filtered by name.
Can anyone advise on how this can be done.
Thank you Kindly
J.
2 Replies
JD_73 My approach would be the other way around. Give each manager their own file with just their data for data entry. Then create a centralised report that pulls the data from all manager sheets. This could possibly be done with Power Query.
IngeborgHawighorst Thank You Ingeborg, I will give that a go.
