See Debra Dalgleish's site for "dependent DV lists"

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Thu, 4 Sep 2008 19:07:00 -0700, McSorley
wrote:

Trying to set a selection sheet that contains pick lists based on prior
input. For instance, first pick list would be make of car (Honda Picked),
second pick list would be model of car (Accord, Pilot, Civic, etc). The
second pick list would only identify options available based on the first
answer.