Posted to microsoft.public.excel.worksheet.functions
|
|
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...
|