Hi Charles

It was really a helpful site. i tried it with my workbook & it worked. But
now my problem is I am having 30 more named regions :(.
I think a macro should solve it or I think the list should be created based
on the selection (instead of creating multiple named regions.)

"Charles Chickering" wrote:

Sara, try this article from Ozgrid on dependant validation lists:
http://www.ozgrid.com/Excel/dependent-lists.htm
--
Charles Chickering

"A good example is twice the value of good advice."