Show columns based on drop down selection

[newbiee]

Hello,


i would like to ask how to show columns based on what i choose in dropdown?


I have column "Motor" and next to it column "Part Number" and on other side i have a table of machines.

What i want is that when i select "Part Number" i want only machines to be displayed that use this "Part Number".

Example:

I select Part Number from dropdown list: 3-340.02.1004

Than only machines PPS4,PPS11, PPS40 are displayed in table

If nothing is selected all machines are shown.

The problem is that i need to somehow "assign" machines to particular "Part Number", how do i do this?


Thanks

 

[Legacy 143009]

Do you have a Part Number-Machine table? First, you should have this table. Excel can not know which part number belongs to which machine.