how do i "link" two sets of named ranges

[des-sa]

please help. we're working with motor vehicles. in sheet 1 there are
several lists with the make as a column header (say "FORD" in column A) with
the various "FORD" models listed below (say F100, F250 etc).

is there a way of having the data validated in sheet 2 where, if in column A
i select "FORD", then in column B i can only select one of the ford models?

thanking you

 

[Gary''s Student]

See:

http://www.contextures.com/xlDataVal02.html

 

[des-sa]

thanks a 1000000

See:

http://www.contextures.com/xlDataVal02.html