how do i "link" two sets of named ranges

  • Thread starter Thread starter des-sa
  • Start date Start date
D

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
 
Back
Top