Is this possible in Excel
 

I wish to create a worksheet with a drop down list of tools which i
can pick the tools I need and create a list to give to someone to get
ready ,this I can do but what i also want to be able to do is ,
If I pick tool "A" and their are several other tools assocatated with
tool "A" when I pick tool "A" from my drop down list these assocatated
tools are automatically picked at the same time and put into the same
list as tool "A"

TIA

Is this possible in Excel
 

Closest I can think of to what you are looking for is Depenedent Validation.
Debra Dalgleish has instructions he-

http://www.contextures.com/xlDataVal02.html

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



wrote in message
...
I wish to create a worksheet with a drop down list of tools which i
can pick the tools I need and create a list to give to someone to get
ready ,this I can do but what i also want to be able to do is ,
If I pick tool "A" and their are several other tools assocatated with
tool "A" when I pick tool "A" from my drop down list these assocatated
tools are automatically picked at the same time and put into the same
list as tool "A"

TIA