Hi, I wonder whether someone may be able to help me please.
I'm using the attached file to record staff resource.
www.box.com/s/4eauffqp2q9wbp5eat39
If you change the value in column I to either "BC", "BNC" or "OH", the value in column J will change to "--Select--", prompting the user to select a value from the drop down menu. The drop down values in this column are retrieved from the "Lists" sheet via a INDIRECT Data Validation formula.
I do however have one problem.
If you change the value in column I to "P", you'll see that the value in column J changes to "Enter the Project Code", which via my VBA code allows the user to populate this with free text.
The problem I have is that users are entering all manner of descriptions, which cause problems when evaluating the data.
So what I'd like to do is to maintain the exisiting functionality, but when they are asked to "Enter the Project Code", I'd like the user to be resticted to 4 alphanumeric characters but I'm a little unsure about how to do this because I'm already using the INDIRECT Data Validation in this cell.
I just wondered whether someone could possibly take a look at this please and offer some guidance on how I may go about this.
Many thanks and kind regards
Chris
I'm using the attached file to record staff resource.
www.box.com/s/4eauffqp2q9wbp5eat39
If you change the value in column I to either "BC", "BNC" or "OH", the value in column J will change to "--Select--", prompting the user to select a value from the drop down menu. The drop down values in this column are retrieved from the "Lists" sheet via a INDIRECT Data Validation formula.
I do however have one problem.
If you change the value in column I to "P", you'll see that the value in column J changes to "Enter the Project Code", which via my VBA code allows the user to populate this with free text.
The problem I have is that users are entering all manner of descriptions, which cause problems when evaluating the data.
So what I'd like to do is to maintain the exisiting functionality, but when they are asked to "Enter the Project Code", I'd like the user to be resticted to 4 alphanumeric characters but I'm a little unsure about how to do this because I'm already using the INDIRECT Data Validation in this cell.
I just wondered whether someone could possibly take a look at this please and offer some guidance on how I may go about this.
Many thanks and kind regards
Chris