dependent lists and data presentation
 

Hello Everybody,

I wonder if you can help on this one....I am setting up a calendar in
which I have a list of services shorted per date. These services take
place in different locations and for different clients.

I have created three dependent lists; the first one with a list of
countries, the second one with a list a cities depending on the
country choosen, and the thirth one with a list of clients dependent
on the city of choice.

Once the person has chosen this thirth cathegory I want excel to
present a compilation of the information that fits the chosen
criteria..is there a way of doing this that is not too complicated?
I have been looking through the posts and could not manage to find a
similar case...
I would very much appreciate your help on this one!!!!!

Thank you so much in advance,

dependent lists and data presentation
 

Start here;;

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

HTH,
Jim

"CaOrAl" wrote in message
ups.com:

Hello Everybody,

I wonder if you can help on this one....I am setting up a calendar in
which I have a list of services shorted per date. These services take
place in different locations and for different clients.

I have created three dependent lists; the first one with a list of
countries, the second one with a list a cities depending on the
country choosen, and the thirth one with a list of clients dependent
on the city of choice.

Once the person has chosen this thirth cathegory I want excel to
present a compilation of the information that fits the chosen
criteria..is there a way of doing this that is not too complicated?
I have been looking through the posts and could not manage to find a
similar case...
I would very much appreciate your help on this one!!!!!

Thank you so much in advance,

dependent lists and data presentation
 

On Feb 14, 11:14 am, "JMay" wrote:
Start here;;

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

HTH,
Jim

"CaOrAl" wrote in message

ups.com:



Hello Everybody,

I wonder if you can help on this one....I am setting up a calendar in
which I have a list of services shorted per date. These services take
place in different locations and for different clients.

I have created three dependent lists; the first one with a list of
countries, the second one with a list a cities depending on the
country choosen, and the thirth one with a list of clients dependent
on the city of choice.

Once the person has chosen this thirth cathegory I want excel to
present a compilation of the information that fits the chosen
criteria..is there a way of doing this that is not too complicated?
I have been looking through the posts and could not manage to find a
similar case...
I would very much appreciate your help on this one!!!!!

Thank you so much in advance,- Hide quoted text -

- Show quoted text -

Thank you for that one Jim,

I already looked at that one to help me create the dependent
lists...however I cannot see how this can help me to do what I am
intending...maybe I did not explain my issue properly....I have not
created the dependent lists for users to input information but rather
help them to look exactly the information they are looking for...the
filtering function would make this job but I want to do it more user-
friendly....Then the idea would be that once they have chosen the
three cathegories IE; Spain- Barcelona-ClientX they get a list of all
services under all these criteria,

Thank you