View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dire straits
 
Posts: n/a
Default select list by selecting a cell

PS: I rate the reply five stars *****.

"Biff" wrote:

i!

Are you talking about data validation drop down lists?

If so, yes, you can do this.

Need more detail for a better solution but in general this is how you would
do it:

The main list would contain the names of all the other lists. The selection
made from that list would dictate which sublist is displayed in the other
cell.

See this:

http://contextures.com/xlDataVal02.html

Biff

"Dire straits" <Dire wrote in message
...
I have created four lists. List A is the main type list and List B, C and
D
are the sub-types. Is it possible that by selecting a value in List A in
a
cell, I can call List B, C or D in another cell.
Please help...