Values in drop down box dynamic

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

Chris, take a look at this page from Debra Dalgleish's Website:
http://www.contextures.com/xlDataVal02.html.
--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


"Chris" wrote in message
...
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