Creating further drop down lists after a selection from a list

[Paul Gee]

Is there a way I can have a new drop down selection offered after a selection
is made from another drop down list? I don't just want to have the next list
already available, but rather dependant on the item selcted from the first
list.

Therefore if "YESY" was selected a new list is then available with multiple
selections.

 

[Tausif]

Hi Paul,

I had created this file for some other user whose requirements are similar
to yours.

You can download it from the link below.

http://rapidshare.com/files/132101437/Book1.xls.html

HTH,

 

[Paul Gee]

Thanks - When my IT Dept allow me to access will take a look - Firewall
blocking that site right now!

 

[Paul Gee]

I cannot download that example so i am still lost - Spent last 5 hours trying
to work it out and now banging head against wall !!