I am looking for assistance in creating a program that filters data based on multiple user defined filter selections and outputs the results into a new worksheet in the same workbook.
The user interface will have multiple drop down boxes in categories such as:
Size: 100, 200, 300
Color: Red, Blue, Green, Yellow
Number: 1, 2, 3
Where the user will select an option out of each drop down box.
Simplified data looks something like this:
Company, Size, Color, Number, Shape
A, 100, Red, 2, Circle
A, 100, Blue, 2, Square
A, 200, Red, 1, Circle
B, 100, Red, 2, Triangle
B, 300, Green, 3, Circle
C, 100, Yellow, 1, Square
So when the user selects certain kinds of criteria, for example, Size 100, Color red, and Number 2, the program would filter data and would output the results and the corresponding data in a new worksheet in the same workbook.
Company A, Size 100, Color Red, Number 2, Circle
Company B, Size 100, Color Red, Number 2, Triangle
Any help would be REALLY appreciated. Thank you
The user interface will have multiple drop down boxes in categories such as:
Size: 100, 200, 300
Color: Red, Blue, Green, Yellow
Number: 1, 2, 3
Where the user will select an option out of each drop down box.
Simplified data looks something like this:
Company, Size, Color, Number, Shape
A, 100, Red, 2, Circle
A, 100, Blue, 2, Square
A, 200, Red, 1, Circle
B, 100, Red, 2, Triangle
B, 300, Green, 3, Circle
C, 100, Yellow, 1, Square
So when the user selects certain kinds of criteria, for example, Size 100, Color red, and Number 2, the program would filter data and would output the results and the corresponding data in a new worksheet in the same workbook.
Company A, Size 100, Color Red, Number 2, Circle
Company B, Size 100, Color Red, Number 2, Triangle
Any help would be REALLY appreciated. Thank you
