Create a dependant drop down list

[Osvaldo]

Hello All.
I have the following situation in a spreadsheet (Excel 2007):
Sheet1
Column A = Project
Column B = Products
Column C = Suppliers

In Sheet2, I need to create 3 drop down lists (Project / Products / Suppliers), that every time I select a Project, only displays the products and suppliers that are available for that project. I thought that I could use the Pivot Table Report Filter, but it is not dependent, and it lists all products and suppliers regardless of my project.

I really appreciate your help.

 

[T. Valko]

Hello All.
I have the following situation in a spreadsheet (Excel 2007):
Sheet1
Column A = Project
Column B = Products
Column C = Suppliers

In Sheet2, I need to create 3 drop down lists (Project / Products / Suppliers), that every time I select a Project, only displays the products and suppliers that are available for that project. I thought that I could use the Pivot Table Report Filter, but it is not dependent, and it lists all products and suppliers regardless of my project.

I really appreciate your help.

See this...

http://contextures.com/xlDataVal02.html

 

[Osvaldo]

See this...

http://contextures.com/xlDataVal02.html

Valko

Thanks but the only problem is that this solution requires to create Named List for every project/product/supplier combination and this is not what I am looking for.
I have a set of data arranged in columns as following:

Project / Product / Supplier
Project1 / Product1 / Supplier1
Project1 / Product2 / Supplier2
Project2 / Product2 / Supplier3
Project2 / Product3 / Supplier2
Project3 / Product3 / Supplier1
Project3 / Product3 / Supplier4
etc
This is a dynamic list because it is updated every time there is a new project.
Products and Suppliers can be used on any project.

I need to create a dependent drop down list that displays only the products and suppliers available for that project, like a Pivot Table with dependent Report Filters.

Thanks
Oz

 

[T. Valko]

Valko

Thanks but the only problem is that this solution requires to create Named List for every project/product/supplier combination and this is not what I am looking for.
I have a set of data arranged in columns as following:

Project / Product / Supplier
Project1 / Product1 / Supplier1
Project1 / Product2 / Supplier2
Project2 / Product2 / Supplier3
Project2 / Product3 / Supplier2
Project3 / Product3 / Supplier1
Project3 / Product3 / Supplier4
etc
This is a dynamic list because it is updated every time there is a new project.
Products and Suppliers can be used on any project.

I need to create a dependent drop down list that displays only the products and suppliers available for that project, like a Pivot Table with dependent Report Filters.

Thanks
Oz

Sorry, I don't understand.

Maybe someone else will be able to help.

Good luck!

 

[ravi4ever]

you will have to use dynamic named ranges..

I believe you are looking for this..

http://www.get-digital-help.com/201...s-containing-unique-distinct-values-in-excel/