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