Drop down menu
 

Ive created a drop down list box from the Data Validation tab with the
following text, Austin, Houston, and Dallas. I created another drop down
list for an each cities stores (each has15 locations). I want choose one city
and only the corresponding locations will show, how do I accomplish this
task? Is there a formula I need to create?

Thank you in advance,

Drop down menu
 

See the Dependent Lists section of Debra Dalgleish's excellent website for
instructions:

http://www.contextures.com/xlDataVal02.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Randall" wrote:

Ive created a drop down list box from the Data Validation tab with the
following text, Austin, Houston, and Dallas. I created another drop down
list for an each cities stores (each has15 locations). I want choose one city
and only the corresponding locations will show, how do I accomplish this
task? Is there a formula I need to create?

Thank you in advance,

Drop down menu
 

You need to create a table that lists all the stores for each location.

Assume your drop down is in A1 and has the selections for the locations:
Austin, Houston, Dallas

In some area of your sheet create a table like this:

...............F...............G................H
1........Austin.......Houston.......Dallas
2..........A1..............H1.............D1
3..........A2..............H2.............D2
4..........A3..............H3.............D3


Now, give each one of these columns a defined name:

Select the range F2:F4 then click in the name box (all the way on the left
side of the formula bar where it shows you what cell is selected) and type
in Austin then hit ENTER. Do the same for the other columns and name them
Houston and Dallas.

Now, set up your dependent drop down:

Assume you want this drop down in cell B1.
Select cell B1
Goto DataValidation
Allow: List
Source: =INDIRECT(A1)
OK

If you currently have nothing selected from the drop down in A1 you will get
a message saying that the source current evaluates to an error and do you
wish to continue. Just select Yes.

Biff

"Randall" wrote in message
...
I've created a drop down list box from the Data Validation tab with the
following text, Austin, Houston, and Dallas. I created another drop down
list for an each cities stores (each has15 locations). I want choose one
city
and only the corresponding locations will show, how do I accomplish this
task? Is there a formula I need to create?

Thank you in advance,

Drop down menu
 

Randall

See Debra Dalgleish's site for how-to.

http://www.contextures.on.ca/xlDataVal02.html




On Mon, 27 Nov 2006 09:27:01 -0800, Randall
wrote:

I’ve created a drop down list box from the Data Validation tab with the
following text, Austin, Houston, and Dallas. I created another drop down
list for an each cities stores (each has15 locations). I want choose one city
and only the corresponding locations will show, how do I accomplish this
task? Is there a formula I need to create?

Thank you in advance,


Gord Dibben MS Excel MVP

Drop down menu
 

"Gord Dibben" wrote:

Randall

See Debra Dalgleish's site for how-to.

http://www.contextures.on.ca/xlDataVal02.html

Thank you for the great information, I found it very useful and easy to administer. I am on to the next level, VLookup and IF statements.
Randall


On Mon, 27 Nov 2006 09:27:01 -0800, Randall
wrote:

Ive created a drop down list box from the Data Validation tab with the
following text, Austin, Houston, and Dallas. I created another drop down
list for an each cities stores (each has15 locations). I want choose one city
and only the corresponding locations will show, how do I accomplish this
task? Is there a formula I need to create?

Thank you in advance,


Gord Dibben MS Excel MVP

Drop down menu
 

See Debra's site also for great help on VLOOKUP.

http://www.contextures.on.ca/xlFunctions02.html


Gord

On Mon, 27 Nov 2006 12:40:02 -0800, Randall
wrote:



"Gord Dibben" wrote:

Randall

See Debra Dalgleish's site for how-to.

http://www.contextures.on.ca/xlDataVal02.html

Thank you for the great information, I found it very useful and easy to administer. I am on to the next level, VLookup and IF statements.
Randall


On Mon, 27 Nov 2006 09:27:01 -0800, Randall
wrote:

I’ve created a drop down list box from the Data Validation tab with the
following text, Austin, Houston, and Dallas. I created another drop down
list for an each cities stores (each has15 locations). I want choose one city
and only the corresponding locations will show, how do I accomplish this
task? Is there a formula I need to create?

Thank you in advance,


Gord Dibben MS Excel MVP


Gord Dibben MS Excel MVP