| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Lists
I think I have a good one here. I have a drop down list, say in cell "C5",
that pulls/populates a bunch of different codes from another sheet (called "SCHDC Codes")in the same workbook. Now I have another sheet (called "NHDC Codes") also in the same workbook that has a whole other set of codes. What I would like to do is, lets say if cell "A1" has an "X" in the cell, I would like the drop down list in cell "C5" to populate from the "SCHDC Codes"...If cell "B1" has an "X" in the cell I would like the same drop down list in cell "C5" to pull from the "NHDC Codes" rather than the "SCHDC Codes"... I hope I explained this good enough. Basically I need the drop down list to change info based on an "X" from two different cells. Is this even possible? If so, How could I accomplish this task? -- Randy Street Rancho Cucamonga, CA |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down Lists
See ..
http://www.contextures.com/xlDataVal02.html "Randy" wrote: I think I have a good one here. I have a drop down list, say in cell "C5", that pulls/populates a bunch of different codes from another sheet (called "SCHDC Codes")in the same workbook. Now I have another sheet (called "NHDC Codes") also in the same workbook that has a whole other set of codes. What I would like to do is, lets say if cell "A1" has an "X" in the cell, I would like the drop down list in cell "C5" to populate from the "SCHDC Codes"...If cell "B1" has an "X" in the cell I would like the same drop down list in cell "C5" to pull from the "NHDC Codes" rather than the "SCHDC Codes"... I hope I explained this good enough. Basically I need the drop down list to change info based on an "X" from two different cells. Is this even possible? If so, How could I accomplish this task? -- Randy Street Rancho Cucamonga, CA |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down Lists
Thank you! That helped out a lot. I was able to figure out what I needed to
do. -- Randy Street Rancho Cucamonga, CA "Toppers" wrote: See .. http://www.contextures.com/xlDataVal02.html "Randy" wrote: I think I have a good one here. I have a drop down list, say in cell "C5", that pulls/populates a bunch of different codes from another sheet (called "SCHDC Codes")in the same workbook. Now I have another sheet (called "NHDC Codes") also in the same workbook that has a whole other set of codes. What I would like to do is, lets say if cell "A1" has an "X" in the cell, I would like the drop down list in cell "C5" to populate from the "SCHDC Codes"...If cell "B1" has an "X" in the cell I would like the same drop down list in cell "C5" to pull from the "NHDC Codes" rather than the "SCHDC Codes"... I hope I explained this good enough. Basically I need the drop down list to change info based on an "X" from two different cells. Is this even possible? If so, How could I accomplish this task? -- Randy Street Rancho Cucamonga, CA |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down Lists
This is a TOTALLY COOL feature! I'm having lots of fun with it! THANKS!
"Toppers" wrote: See .. http://www.contextures.com/xlDataVal02.html "Randy" wrote: I think I have a good one here. I have a drop down list, say in cell "C5", that pulls/populates a bunch of different codes from another sheet (called "SCHDC Codes")in the same workbook. Now I have another sheet (called "NHDC Codes") also in the same workbook that has a whole other set of codes. What I would like to do is, lets say if cell "A1" has an "X" in the cell, I would like the drop down list in cell "C5" to populate from the "SCHDC Codes"...If cell "B1" has an "X" in the cell I would like the same drop down list in cell "C5" to pull from the "NHDC Codes" rather than the "SCHDC Codes"... I hope I explained this good enough. Basically I need the drop down list to change info based on an "X" from two different cells. Is this even possible? If so, How could I accomplish this task? -- Randy Street Rancho Cucamonga, CA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop-down lists | Excel Discussion (Misc queries) | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| drop down lists | Excel Worksheet Functions | |||
| Drop down lists | Excel Discussion (Misc queries) | |||
| Drop Down LIsts | Excel Worksheet Functions | |||
Linear Mode
