Hello everyone. I'm sorry if this is a similar to other posts but I've searched and tried to modify posted codes to no avail. After 7hrs of attempting on my own - I'm giving up ! I freely admit that I have no idea what I'm doing when it comes to code.
Here's what I'm trying to do:
For each row, users must select from a validation drop-down menu either "Yes" or "No" in Column A.
Once Column A is complete, the remainder of the row will unlock.
I have tried to enter in validation =NOT(TRIM(A2)="") but this will not clear the user's entry. VB code would be more useful, I think, but you can direct me better in this.
Would some one be able to help? Please let me know if I need to provide more information.
Thank you in advance for your time.
Here's what I'm trying to do:
For each row, users must select from a validation drop-down menu either "Yes" or "No" in Column A.
Once Column A is complete, the remainder of the row will unlock.
I have tried to enter in validation =NOT(TRIM(A2)="") but this will not clear the user's entry. VB code would be more useful, I think, but you can direct me better in this.
Would some one be able to help? Please let me know if I need to provide more information.
Thank you in advance for your time.