I am trying to make a quotation form with dropdown lists derived from a price list. However I want a second dropdown to be filtered based upon the selection from the first which only shows unique items. For example my price list looks like:
Manufacturer Model Description Price
Fluke 77 Digital Multimeter 33.00
fluke 87 Digital Multimeter 35.00
Agilent 34401A DMM 110.00
Tektronix TDS744A Oscilloscope 100.00
Tektronix 2245A Oscilloscope 85.00
As you can see, on my quote form, I would have a dropdown list under "Manufacturer" but I only want it to show each manufacturer once. Then I want a dropdown list for the "Model", this list would only show model numbers that match the manufacturer selected in the first dropdown.
I tried to use data validation and named ranges, but I can very easily exceed 256 columns very quickly.
P.S. while I am at it I would also like a button on this worsheet "Add Item" that would bring up a userform prompting for the Mfr,Model,Description,and Price, and add this info to the price list.
Any help would be greatly appreciated, Thank You.
Reply With Quote
