ExcelBanter - Lists referencing lists...is it possible?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Lists referencing lists...is it possible? (https://www.excelbanter.com/excel-worksheet-functions/114991-lists-referencing-lists-possible.html)

JohnB

Lists referencing lists...is it possible?

I am looking to create two different lists for users to chose from. However,
I would like the second list to be dependent upon the item selected in the
first list. Is this possible?

Ron Coderre

Lists referencing lists...is it possible?

Try using Data Validation with Dependent Lists:

Debra Dalgleish's website shows you how:
http://www.contextures.com/xlDataVal02.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"JohnB" wrote:

I am looking to create two different lists for users to chose from. However,
I would like the second list to be dependent upon the item selected in the
first list. Is this possible?

JohnB

Lists referencing lists...is it possible?

That is EXACTLY what I need...thank you so much.

jb

"Ron Coderre" wrote:

Try using Data Validation with Dependent Lists:

Debra Dalgleish's website shows you how:
http://www.contextures.com/xlDataVal02.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"JohnB" wrote:

I am looking to create two different lists for users to chose from. However,
I would like the second list to be dependent upon the item selected in the
first list. Is this possible?

All times are GMT +1. The time now is 11:59 PM.