I have a file that is updated by 2 groups of people.
For some of the cells, I don't want group 1 to be able to update but they need to be able to update other cells.
It would be the same for group 2.
therefore.... Column A,B,C & D can only be updated by members within Group 1 & Columns E,F,G&H can only be updated by members within Group 2.
I thought using the Protect Sheet icon would do this but I can't get it to work
Any suggestions?
For some of the cells, I don't want group 1 to be able to update but they need to be able to update other cells.
It would be the same for group 2.
therefore.... Column A,B,C & D can only be updated by members within Group 1 & Columns E,F,G&H can only be updated by members within Group 2.
I thought using the Protect Sheet icon would do this but I can't get it to work
Any suggestions?