Data Validation: Drop-down list in one cell and auto complete in another cell

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
 

Forum statistics

Threads
1,082,501
Messages
5,365,942
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top