Hi,

I have seen similar posts but none quite fitting my specific need. My need would be better suited to a database, but alas I am stuck with excel for this one. My aim is to create a password protected column with different passwords based on a person's name in the preceding column.
e.g. if Column B has a list of names, only that person should be able to insert info in column c for that specific row where they are referenced. I know that password protection/ user permissions can be assigned to a named range, hence I thought of creating a named range of sort. The problem is I am struggling to create a dynamic named range for column c for data that is not sequential.

I am probably missing a simple logical trick.

Thanks in advance.