creat a drop/down sub list from a main list

I don't think it is possible in Excel. The only ones where I have seen dependent validation lists are with two columns.

validation

Hi
It is possible to have a sub list from a main list
See this site on validation
I haven't found the thread yet but it is there
Hope this helps
Jim Henderson

Quote from helmekki

Hi
I have no problem creating lists using Data validation and formulas...

i want to creat a sub list from a main list...
so when displaying an item from the main list, another sub list appear to show sub items that are linked to the main item in the main list

however, i wnat to use only one column, not two or three columns

yours
hesham

Display More

This might be what you're looking for.

http://www.ozgrid.com/FreeDownloads/MatchingLists.zip

Rich