Forum Discussion
JD_73
May 09, 2019Copper Contributor
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 se...
May 09, 2019
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.
JD_73
May 12, 2019Copper Contributor
IngeborgHawighorst Thank You Ingeborg, I will give that a go.