How to do lists

[hshsd]

hello,

I wan´t to create a List of cities, and afer that in other cell I want, to
put the clientes of that city.

Example If in the firts cell I get City o New York and Boston, I want that
in the second cell, only appeard the clients from those city.
Because I have a listo of 50 cityes and on other way the total of clients
are 750 from all of those cityes.

So i want that people only with a few cliks on the mouse could sellect the
cities and the clients on those cities that they should visit.

Thanks

 

[Eduardo]

Hi
Take a Look at Debra web

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

 

[Bob I]

http://search.live.com/results.aspx?q=excel+cascading+lists&go=&form=QBLH

 

[Gav123]

Hi,

It sounds like you need to use Data Validation...

This site is very usefull...

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

Hope this helps,

Gav