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

Re: Excel Protecting cells for named people
 

Get them to send the information and then update the spreadsheet yourself? You’re right, people will mess it up.

Re: Excel Protecting cells for named people
 

seconded