• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple Combo Lists

anon1m0us

New Member
Hi,

I have a sheet that has a bunch of data. For example,

Sheet1
CompanyName CompanyCode Legalname Address
Costo 123 Test1 18to Life Blvd
Costco 456 Notme Work Street
Target 789 test2 Sample Court




My Combolist1 needs to have a distinct entry for the Company name. Once selected, ComboList2 it should only show the CompanyCode for that Companyname.
I have a second Sheet that contains Vendors.

Sheet2
CompanyName Vendor name
Costo Plumber
Target Maintenance

My Combolist3 should only show the vendors under that CompanyName.

My data is being pulled straight from a Database, and I have named ranges, but I cannot get it to work.
Any ideas?
 
Back
Top