Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 634
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
Open Excel 2003 from Windows Explorer pmpjr Excel Discussion (Misc queries) 9 September 11th 06 03:58 PM
Need suggestions for some uses of Ms Excel Bible John Excel Discussion (Misc queries) 1 February 27th 06 05:30 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM


All times are GMT +1. The time now is 10:16 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"