Hello all,
I'm new to this forum but I have had an issue that I have been trying to find a work around for a while now.
I have a drop down with a list of people on our teams initials.
I want to develop a way that when people select their initials (any of the ones on the Defined Name) the cell to the right shows confirmation of them checking the work.
Initially I used a Check box with linked cell formula using IF statements to indicate when to tick the box. The issue with this was that I had to lock the cells and protect the sheet to make sure people didn't tick the box manually and mess up the formula.
I decided to abolish this as protecting the sheet created to many restrictions when running in a shared workbook ie moving and deleting rows and Data Sorting.
So, what I would like nowis a "Checked" Column to the right of the "Initials" column whereby when any of the given initials are selected one of the following to things happens:
1. A tick mark appears in the "Checked" column to the right
2. The text "Yes" appears there instead.
I think I need to put a VLOOKUP in the "Checked" column to say that if any of the Defined Initials are inputted in the Initials column please enter "YES" (or a tick).
Can anyone help me with the formula for this and if so is there a way to lock the formula into the cells so noone can ammend, without protecting the sheet!
I did see some coding where you can lock specific cells (and it moved you to the right cell) without locking the sheet so I may try this method once I have formula.
Please see below my example
And the data sheet with the two defined names
Thanks guys
James
I'm new to this forum but I have had an issue that I have been trying to find a work around for a while now.
I have a drop down with a list of people on our teams initials.
I want to develop a way that when people select their initials (any of the ones on the Defined Name) the cell to the right shows confirmation of them checking the work.
Initially I used a Check box with linked cell formula using IF statements to indicate when to tick the box. The issue with this was that I had to lock the cells and protect the sheet to make sure people didn't tick the box manually and mess up the formula.
I decided to abolish this as protecting the sheet created to many restrictions when running in a shared workbook ie moving and deleting rows and Data Sorting.
So, what I would like nowis a "Checked" Column to the right of the "Initials" column whereby when any of the given initials are selected one of the following to things happens:
1. A tick mark appears in the "Checked" column to the right
2. The text "Yes" appears there instead.
I think I need to put a VLOOKUP in the "Checked" column to say that if any of the Defined Initials are inputted in the Initials column please enter "YES" (or a tick).
Can anyone help me with the formula for this and if so is there a way to lock the formula into the cells so noone can ammend, without protecting the sheet!
I did see some coding where you can lock specific cells (and it moved you to the right cell) without locking the sheet so I may try this method once I have formula.
Please see below my example
And the data sheet with the two defined names
Thanks guys
James
