LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default Drop down lists

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple lists with repeated values for dependet drop down lists mcmanusb Excel Worksheet Functions 1 September 29th 06 12:13 AM
How do I have hierarchial drop down lists in Excel Kunal Excel Worksheet Functions 2 March 20th 06 03:08 PM
drop down lists johnny.exe New Users to Excel 2 March 3rd 06 06:35 PM
Drop Down Lists geeksrgood Excel Worksheet Functions 0 December 5th 05 06:47 AM
Can different drop down lists be displayed depending on the value. Laurentd Excel Discussion (Misc queries) 1 February 24th 05 12:31 AM


All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"