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?
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?
