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

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