spreadsheet protection

Copper Contributor

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. 


@Ingeborg Hawighorst Thank You Ingeborg, I will give that a go.