Hi All,
This board is amazing!! I've been searching trying to find the answer to my problem, but can't find precisely what I'm after, so I'll try a new post. Please forgive me if this is something covered in previous topics.
Is there any way to populate the input range of a combo box in a worksheet with dynamic information, ie the result of a filtered list?
I have a long list of products in say, 3 columns, each product with a grouping code attached :
A1: 0001 B1: Brakes C1: $40.00
A2: 0001 B2: Tires C2: $55.00
A3: 0001 B3: Filters C3: $ 6.00
A4: 0002 B4: Widgets C4: $10.00
(0001 Brakes, 0001 Tires, 0001 Filters would all be in group 0001). The list changes at least once a week as we add or remove products.
I want to position one combo box per group on a separate tab that uses for its input range the result of filtering the long list by the applicable grouping code. The value returned would be fed to the order sheet to populate the customer's invoice.
So combo box 1 would allow the clerk to select only from the items that have "0001" as the grouping code, combo box 2 would allow selection from all items with "0002" as the code, etc. In a list of approx 5000 products, there are about 60 groups.
I know this is probably better handled through a database, but you folks seem to be able to do ANYTHING with Excel and VBA. I'm willing to modify my approach if you can steer me in the right direction.
Many thanks!
This board is amazing!! I've been searching trying to find the answer to my problem, but can't find precisely what I'm after, so I'll try a new post. Please forgive me if this is something covered in previous topics.
Is there any way to populate the input range of a combo box in a worksheet with dynamic information, ie the result of a filtered list?
I have a long list of products in say, 3 columns, each product with a grouping code attached :
A1: 0001 B1: Brakes C1: $40.00
A2: 0001 B2: Tires C2: $55.00
A3: 0001 B3: Filters C3: $ 6.00
A4: 0002 B4: Widgets C4: $10.00
(0001 Brakes, 0001 Tires, 0001 Filters would all be in group 0001). The list changes at least once a week as we add or remove products.
I want to position one combo box per group on a separate tab that uses for its input range the result of filtering the long list by the applicable grouping code. The value returned would be fed to the order sheet to populate the customer's invoice.
So combo box 1 would allow the clerk to select only from the items that have "0001" as the grouping code, combo box 2 would allow selection from all items with "0002" as the code, etc. In a list of approx 5000 products, there are about 60 groups.
I know this is probably better handled through a database, but you folks seem to be able to do ANYTHING with Excel and VBA. I'm willing to modify my approach if you can steer me in the right direction.
Many thanks!
