How to do lists
 

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

How to do lists
 

Hi
Take a Look at Debra web

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

"hshsd" wrote:

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

How to do lists
 

http://search.live.com/results.aspx?...&go=&form=QBLH

hshsd wrote:

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

How to do lists
 

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

"hshsd" wrote:

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