Dougie1
Board Regular
- Joined
- Jul 27, 2007
- Messages
- 212
Hi all,
Using Excel 2003
I hope somebody can help me with another question on dependent dropdowns.
I have a spreadsheet which uses the methodology of Data Validation in column B to allow a List and sets the Data Validation Source as =INDIRECT(“L”&A2) where L refers to my possible selection of lists for column B (these lists are called L1, L2, L3, L4 etc and have been defined as such). This then generates a list of options in the cell B2 dropdown list dependent on what the value is in A2. This A2 value has also been selected from a list.
Basically, this has the effect of restricting what the user options are in column B dependent on what has been selected as an option in column A. Now this works fine.
But what I have come to realise is that a user can select an option from the list in column A, then go onto select an option from column B (these options in column B are now restricted by their column A selection), but after they have selected their column B option, they can simply then go back and change the column A option, and I will be left with a combination in columns A & B which I don't want.
I would like to know if there is a way that I can prevent this from happening (or at least generate a warning message) if the column B selection does not relate to the correct column A selection.
Thanks in advance,
D
Using Excel 2003
I hope somebody can help me with another question on dependent dropdowns.
I have a spreadsheet which uses the methodology of Data Validation in column B to allow a List and sets the Data Validation Source as =INDIRECT(“L”&A2) where L refers to my possible selection of lists for column B (these lists are called L1, L2, L3, L4 etc and have been defined as such). This then generates a list of options in the cell B2 dropdown list dependent on what the value is in A2. This A2 value has also been selected from a list.
Basically, this has the effect of restricting what the user options are in column B dependent on what has been selected as an option in column A. Now this works fine.
But what I have come to realise is that a user can select an option from the list in column A, then go onto select an option from column B (these options in column B are now restricted by their column A selection), but after they have selected their column B option, they can simply then go back and change the column A option, and I will be left with a combination in columns A & B which I don't want.
I would like to know if there is a way that I can prevent this from happening (or at least generate a warning message) if the column B selection does not relate to the correct column A selection.
Thanks in advance,
D