ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Drop Down Lists (https://www.excelbanter.com/excel-discussion-misc-queries/164951-drop-down-lists.html)

Heather Fabries

Drop Down Lists
 
I have a drop down list in one cell with answers a, b, and c. I would like
to have a drop down box in the cell next to it that gives choices based on
the choice made in drop down list 1. For example, if I click on (a) in the
first drop down list, I would like tha choices 1, 2, or 3 in the 2nd drop
down list. If I click on (b) in the first drop down list, I would like tha
choices 4, 5, or 6 in the 2nd drop down list. Is this possible in Excel
2007?

Peo Sjoblom

Drop Down Lists
 
http://www.contextures.com/xlDataVal02.html


--


Regards,


Peo Sjoblom



"Heather Fabries" <Heather wrote in
message ...
I have a drop down list in one cell with answers a, b, and c. I would like
to have a drop down box in the cell next to it that gives choices based on
the choice made in drop down list 1. For example, if I click on (a) in
the
first drop down list, I would like tha choices 1, 2, or 3 in the 2nd drop
down list. If I click on (b) in the first drop down list, I would like tha
choices 4, 5, or 6 in the 2nd drop down list. Is this possible in Excel
2007?




pinmaster

Drop Down Lists
 
Hi,

Start by creating the 3 list you mention somewhere out of sight in your
workbook, next name those 3 list something like... Alist, Blist and Clist,
since C is reserved for column selection you cannot use "C" for a named
range. Now select your cell you want your second drop down list in and go to
Data/Validation, select "list" from the drop down menu and type
=INDIRECT(A1&"list"), A1 being the original drop down list "A,B,C"....adjust
to suit!

HTH
Jean-Guy

"Heather Fabries" wrote:

I have a drop down list in one cell with answers a, b, and c. I would like
to have a drop down box in the cell next to it that gives choices based on
the choice made in drop down list 1. For example, if I click on (a) in the
first drop down list, I would like tha choices 1, 2, or 3 in the 2nd drop
down list. If I click on (b) in the first drop down list, I would like tha
choices 4, 5, or 6 in the 2nd drop down list. Is this possible in Excel
2007?



All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com