sciphinupe
New Member
- Joined
- May 28, 2014
- Messages
- 7
Greetings All,
Excel Question, I am building a worksheet using data validation from a list on a separate tab. Column 1 contains key categories entries and Column 2 contains the subcategories related to Column 1's entry. So, if someone selects "Software problems" in the 1st drop-down list there will be only 4 options available for the user to select in the 2nd drop down list.
The problem is that there are a few key category items with only 1 subcategory to select, and I would like Excel to automatically populate the corresponding cell with "that" selection.
Is there a way to put in some formula in the data validation source-box so that users will be able to select from the drop-down list and, if there's only 1 selection, have Excel automatically populate the correct selection, based on the corresponding reference cell?
Thanks so much,
Sci
Excel Question, I am building a worksheet using data validation from a list on a separate tab. Column 1 contains key categories entries and Column 2 contains the subcategories related to Column 1's entry. So, if someone selects "Software problems" in the 1st drop-down list there will be only 4 options available for the user to select in the 2nd drop down list.
The problem is that there are a few key category items with only 1 subcategory to select, and I would like Excel to automatically populate the corresponding cell with "that" selection.
Is there a way to put in some formula in the data validation source-box so that users will be able to select from the drop-down list and, if there's only 1 selection, have Excel automatically populate the correct selection, based on the corresponding reference cell?
Thanks so much,
Sci
