Update list when changing a cell information.

[mbrooks1009]

Hi Everyone,
Very new here so I hope I can explain what I am trying to do. I have created a lists in order to help roll up costs for items needed to support a project. What I would like to do is have the part numbers and descriptions change if I change the supplier. I would create a drop down of suppliers then need to have their part numbers and descriptions populate the list.

 

[stigcorneer]

Do you have a table that link suppliers to parts? And one that includes all the parts with prices and description?

 

[mbrooks1009]

Do you have a table that link suppliers to parts? And one that includes all the parts with prices and description?

My plan was to build those tables once I knew how to extract the information. Thank you for the reply.

 

[stigcorneer]

My plan was to build those tables once I knew how to extract the information. Thank you for the reply.

Start by building at least the structure of theese first. Then you use them to populate your result and a dropdownlist to filter your result

 

[mbrooks1009]

Start by building at least the structure of theese first. Then you use them to populate your result and a dropdownlist to filter your result

Thank you, I have created 3 tables and a drop down list for the 3 suppliers. I just need to know how to populate the information from each supplier when selected in the drop down.