Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Help
Can I change the content of a drop down list by an entry from another cell?
Example: The ranges C1:C5 has one set of names and D1:D5 has another set of names. Depending on the entry in cell A1 for example, the drop list will dynamically change to show either the list of names in C1:C5 or D1:D5. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Help
You can create a 2 item drop-down list, with appropriate descriptions, where
the user can make a choice between the "C" list or the "D" list. These are called dependent lists, and you can find out all about them from Debra Dalgleish's web site at this page: http://www.contextures.com/xlDataVal02.html -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Glenn" wrote in message ... Can I change the content of a drop down list by an entry from another cell? Example: The ranges C1:C5 has one set of names and D1:D5 has another set of names. Depending on the entry in cell A1 for example, the drop list will dynamically change to show either the list of names in C1:C5 or D1:D5. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Help
Thank you thank you thank you thank you!!!
This is the best way I've seen to solve this problem yet. With a little creativity I was able to get it to work on one of my sheets that had two columns dependent upon the original category. -Jacob F. Roecker "RagDyer" wrote: You can create a 2 item drop-down list, with appropriate descriptions, where the user can make a choice between the "C" list or the "D" list. These are called dependent lists, and you can find out all about them from Debra Dalgleish's web site at this page: http://www.contextures.com/xlDataVal02.html -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Glenn" wrote in message ... Can I change the content of a drop down list by an entry from another cell? Example: The ranges C1:C5 has one set of names and D1:D5 has another set of names. Depending on the entry in cell A1 for example, the drop list will dynamically change to show either the list of names in C1:C5 or D1:D5. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Help
Appreciate the feed-back,
And I'm sure Debra appreciates your enthusiasim. -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Jacob_F_Roecker" wrote in message ... Thank you thank you thank you thank you!!! This is the best way I've seen to solve this problem yet. With a little creativity I was able to get it to work on one of my sheets that had two columns dependent upon the original category. -Jacob F. Roecker "RagDyer" wrote: You can create a 2 item drop-down list, with appropriate descriptions, where the user can make a choice between the "C" list or the "D" list. These are called dependent lists, and you can find out all about them from Debra Dalgleish's web site at this page: http://www.contextures.com/xlDataVal02.html -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Glenn" wrote in message ... Can I change the content of a drop down list by an entry from another cell? Example: The ranges C1:C5 has one set of names and D1:D5 has another set of names. Depending on the entry in cell A1 for example, the drop list will dynamically change to show either the list of names in C1:C5 or D1:D5. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Help
I can't answer people's questions as well as the MVP community yet--I'm
working at it--but at least I can add a little of my own character to the group. "RagDyeR" wrote: Appreciate the feed-back, And I'm sure Debra appreciates your enthusiasim. -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Jacob_F_Roecker" wrote in message ... Thank you thank you thank you thank you!!! This is the best way I've seen to solve this problem yet. With a little creativity I was able to get it to work on one of my sheets that had two columns dependent upon the original category. -Jacob F. Roecker "RagDyer" wrote: You can create a 2 item drop-down list, with appropriate descriptions, where the user can make a choice between the "C" list or the "D" list. These are called dependent lists, and you can find out all about them from Debra Dalgleish's web site at this page: http://www.contextures.com/xlDataVal02.html -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Glenn" wrote in message ... Can I change the content of a drop down list by an entry from another cell? Example: The ranges C1:C5 has one set of names and D1:D5 has another set of names. Depending on the entry in cell A1 for example, the drop list will dynamically change to show either the list of names in C1:C5 or D1:D5. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |