I need help!
Can a combobox populate from an autofilter and control the autofilter?
I have 4 comboboxes. I want to make it so if I click on combobox1 it displays the autofilter results from Column A in the combobox. When you make a selection it makes that selection in the autofilter, for row A. Combobox2 is then populated with possible autofilter choices of column B.And it follows through making each dependent on each other.
When the user is done making there selection (applying the filters), there will be a button for "Go." This will copy the data that is visible after making the 4 selections and begin running it through calculations to generate reports.
Can a combobox populate from an autofilter and control the autofilter?
I have 4 comboboxes. I want to make it so if I click on combobox1 it displays the autofilter results from Column A in the combobox. When you make a selection it makes that selection in the autofilter, for row A. Combobox2 is then populated with possible autofilter choices of column B.And it follows through making each dependent on each other.
When the user is done making there selection (applying the filters), there will be a button for "Go." This will copy the data that is visible after making the 4 selections and begin running it through calculations to generate reports.
