How To do data validation for matching entries between 2 cells based on input in 3rd cell

[diddy47]

I would like to apply data validation to cell K3 based on A3

The value of K3 only comes up after a correct numerical code is entered in K4 (based on the formula in K3 referencing Source! )

basically I want the file to reject the entry in K4 if the resulting value on K3 does not match A3

so as to prevent a different user signing off on a time log that is not tied to their ID

as it currently set up any one can sign off any time log entry... (resulting in the signee being different from A3) the goal is so that only the person selected in A3 can successfully enter a code in K4 so that the K3=A3

[Mumps1]

In a copy of your file, delete all the formulas in column K. Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your "Time Log" sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make an entry in K4 and press the RETURN key.

Please Login or Register  to view this content.

[diddy47]

thank you......the code works very well

[diddy47]

Is there a way to make it work with the cell K3 being protected (before or after?) so that someone can't just delete the generated value in K3 and i suppose K4 would need to lock after a successful entry as well to prevent any alterations?

[Mumps1]

Start by unlocking all the cells in the sheet "Time Log". Then replace the previous macro with the one below:

Please Login or Register  to view this content.

In order to lock the cells, the sheet must be protected. Change the password in the code (in red) to a password of your choosing.

[diddy47]

thank you for this, the code works just perfectly, If I can please ask for you assistance once more.

I just noticed there is a flaw in the excel sheet. How to make it so that A3:J3 ( and subsequent rows A5:J5 etc) is locked after is L5 (MOD sign) signed to complete the data entry for that employee. Ideally L4 will lock as well after entry

[Mumps1]

Try:

Please Login or Register  to view this content.