Hello, me again. I've ran into some issues with pulling certain data from a table and was hoping I could recieve some help. It's hard to put into words exactly what I mean, but hopefully an example will get my point across.
Let's say I have the table:
and more lines are being added everyday. I have a combobox that chooses the category and a listbox that is synced with the drop down to show all the available parts. Is it possible to link both the listbox and dropdown to the data table to form a new table to make a graph from? Preferably with formulas.
Category: Part: Volume: Box 001 1000 Box 003 3000 Tape 101 500 Scissors 201 300 Box 004 2000 Scissors 203 400 Tape 107 600
Example being if I choose [Box] with my combobox and choose both [001] and [004] as my part numbers a new/seperate table would be shown as:
Category Part Volume Box 001 1000 Box 004 2000
I could then have a chart showing data from the new table.
I'm basically trying to create a Slicer but with comboboxes and listboxes. Any help is appreciated.
Thanks.
Reply With Quote
Bookmarks