Values in drop down box dynamic

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I've got one sheet that is used for lookup values. So in
row 1 I have headers -- numbers, letter, colors for
example. In each column, I have values corresponding to
the column it is in (1,2,3 for numbers, etc). In a
different sheet, I have one drop down box that shows
Numbers, Letter, and Colors. What I'd like to do is have a
drop down box whose values are dependent on which value is
selected in the other drop down box. So I should see 1,2,3
in the 2nd drop down box, when I click on Numbers in the
first drop down box.

Anyone have any ideas?

Thanks,
Chris
 
Back
Top