You can use conditional validation pull-downs
http://www.contextures.com/xlDataVal02.html
--
Gary''s Student - gsnu200733
"Matt Brown" wrote:
I want to offer a named range list based on a selection from another list.
ie
if
a1 selection from named range "typesofpet" is "dog" then a2 named range list
= listofdogs
elseif
selection from named range "typesofpets" = to "cat" then a2 named range is =
"listofcats"