Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Just a quick question, I'm using M/S Exel 2003 and would like to know if it's
possible to make a 3 column drop down list that depends on the list before, i.e Column A1 would be €śSize€ť Just a normal list (covering A-Z) Column B1 would be €śWidth€ť Answer from another list but dependent on the fist lists chosen €śLetter€ť Column C1 would be €śLength€ť Answer from another list but dependent on the second lists chosen €śWidth€ť A1 B1 C1 A 10€ť 40€ť Or A1 B1 C1 C 20€ť 50€ť The Letter in column A1 would generate a drop down list of about 10 choices in Column B1 and that in turn would generate a drop down list of about 10 choices in column C1. I have done this with two columns, but can not find any examples for a 3 column. I am only a beginner with Excel and would appreciate any help or advice you could give. Thank you for your time. -- ch |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
How do I have hierarchial drop down lists in Excel | Excel Worksheet Functions | |||
drop down lists | New Users to Excel | |||
Drop Down Lists | Excel Worksheet Functions | |||
Can different drop down lists be displayed depending on the value. | Excel Discussion (Misc queries) |