goto
http://www.contextures.com/tiptech.html
Debra Dalgleish's site and look at
Data Validation - Dependent Lists
--
Regards,
Tom Ogilvy
"Jamesmor" wrote in message
...
Pete,
I have a similiar problem, but don't actually have Excel Hacks, can you
give
me an idea how to get started with this?
"Pete" wrote:
I have tried the example in "Excell Hacks" but it is too complicated to
extend over more than 2 columns. I would like to extend to 10 columns.
A
VBA solution would be OK if necessary.