![]() |
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? |
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 01:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com