Hi All

I have two lists... depending upon the selction of one list I want to
update another list...
e.g. Country List - Here I am listing UK, Ireland
My second List contains Cities, i.e. London, Manchester, Leeds, Dublin etc...

Now if I select UK in Country list I want to display only UK cities in City
list (i.e. London, Machester, Leeds etc) and If I select Ireland then only
Ireland cities (i.e. Dublin etc)

I have implemeted this functionality creating Named ranges... have created
3 lists, gave them name, and used if condition... everything is working
fine... but issue is earlier selection...

If I Select UK... obviously my city list is currently displaying only UK
cities... here if I am selecting lets say London... now when I select Ireland
in country list... my city list is getting updated with Ireland cities but my
previous selection i.e London is still there... I don't want to display
london when I select Irelant... i want to set it either to any default
value... or blank... but certainly not London...

do I need to write a code to do this?? if yes how? bec's macro is not
identifying list?? and what would be the trigger function??

Please help... lokking forward for your prompt reply... thanks

Milind