2 questions...

[puleeese help :\)]

I have gotten myself into alittle mess offering to help
with a project at work and cant seem to find the help on
my own.. I hope someone can help

two questions...
1) I can make the dropdown menu, but is it possible to
make a sub menu within it? For example:
cats
white
black
spotted
dogs
white
black

2) I want to tally what ppl pick from those dropdown
menus and direct them to another worksheet... is this
possible and if so hard?? ugh... oh me and my big mouth

Any help at all would be GREATLY appreciated!!!!
Thanks in advance...

 

[Frank Kabel]

Hi
for the first question you may use two drop downs instead. See:
http://www.contextures.com/xlDataVal02.html