how do i "link" two sets of named ranges
 

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

how do i "link" two sets of named ranges
 

See:

http://www.contextures.com/xlDataVal02.html
--
Gary''s Student - gsnu200832


"des-sa" wrote:

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

how do i "link" two sets of named ranges
 

thanks a 1000000

"Gary''s Student" wrote:

See:

http://www.contextures.com/xlDataVal02.html
--
Gary''s Student - gsnu200832


"des-sa" wrote:

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