Thanks Mark, I've looked at it and so far I see how to do the drop down menus
that are dependend on preceding menus, but I'm not able to find any note on
how to add default value in drop down list or how to manage immediate change
in menus if preceding one is changed. I'm not sure if this can be done via
formulas and excel functions or if I need a macro, in fact I'm trying to
avoid macro in this case. Any idea where coudl I find more on this please?
thx.

"NoodNutt" wrote:

G'day Body

Take a look at Debra Dalgliesh's Website

www.contextures.com

she has a page on multiple cross validation, whereby you can select say a
company in ColumnA which then filters all the names that match that company
in ColumnB, and then viceversa, Select the Name from ColumnB and it will
display the Company in ColumnA.

HTH
Mark.