May 09 2019 05:42 PM
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.
May 09 2019 06:50 PM
@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.
May 12 2019 04:46 PM
@Ingeborg Hawighorst Thank You Ingeborg, I will give that a go.