Is this possible in Excel osiris.luxor[ at ]btopenworld.com 18.07.2006 05:52:30 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

Re: Is this possible in Excel "Ken Wright" <ken.wright[ at ]NOSPAMntlworld.com> 26.08.2006 15:26:09 Closest I can think of to what you are looking for is Depenedent Validation. Debra Dalgleish has instructions here:- 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 :-) ------------------------------­------------------------------­---------------- <osiris.luxor[ at ]btopenworld.com> wrote in message news:bctob2l2uvfha4lfii4oatt63p3b80135h[ at ]4ax.com... [Quoted Text] >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