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

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

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

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