Thread: Excel Protecting cells for named people
View Single Post
Old 27-08-2020, 11:45   #1
Mike
cf.mega poster
 
Join Date: Jan 2004
Age: 63
Posts: 2,242
Mike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful one
Excel Protecting cells for named people
Hi all

I need to send out a large spreadsheet for people to update.

The names are in column C and I would like them to update column P. As there are 100's of names I suggest people filter on their name and update column P accordingly.

Is there 'any way' of protecting column P so only people with the correct name on the same line can update it as I am concerned that people will fill in the wrong cell in column P against somebody else's names.

Hope that makes sense and would appreciate any advice or comment on the best way of doing this.

Many thanks for your help and time

Regards

Mike
Mike is offline   Reply With Quote