Scott
See Debra Dalgeish's site for "dependent DV dropdowns"
http://www.contextures.on.ca/xlDataVal02.html
Gord Dibben MS Excel MVP
On Tue, 19 Dec 2006 09:45:01 -0800, Scott@CW
wrote:
I have a list of 96 names that fall into 7 departments. I have created a data
valaidation list for each grouping. But when I do a IF statement to reference
the DV cell it does not work. Any ideas? I want the user to first choose a
department, then from that choice choose from only the names that fall into
that department group.
Gord Dibben MS Excel MVP