Spare parts drop down list problem

lewis63

New Member
Joined
Sep 7, 2018
Messages
1
Hi
New to this forum & Excel.
i am currently trying to make a customer spare parts quotation but have an issue with selecting "customer" "machine" "serial No." drop down lists. [TABLE="width: 600"]
<tbody>[TR]
[TD]CUSTOMER[/TD]
[TD]MACHINE TYPE[/TD]
[TD]SERIAL No.[/TD]
[/TR]
[TR]
[TD]JOE.BLOGGS[/TD]
[TD]MC TYPE1[/TD]
[TD]1234[/TD]
[/TR]
</tbody>[/TABLE]

My problem is:- we have 4 main "types" of machine, some customers have only 1 machine of 1 type, some have many machines of one type and some up to 3 different types. so how do i get dependent drop down list's to show the choice of up to 4 machine types (if the customer has 3 then show the 3 he has) then once the "type" has been selected. show the serial No.s of all that machine type the customer has.
I have done this with data validation & named cells but as you can't have spaces in the "name" as with the customer name JOE.BLOGGS or JOE_BLOGGS this doesn't look good as an end result.
Would appreciate any help with this as i have been trawling through hundreds of drop down tutorials but none of which suit my dilemma :(
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,223,894
Messages
6,175,250
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top