How to filter table based on cell if a checkbox is selected

Microsoft Excel 2010 - complete product...
March 18, 2016 at 08:32:39
Specs: Windows 7, Intel Core i5-43000 @ 1.90GHz 2.5GHz
I have Data Validation lists in C3:C6 followed by a macro button that adds the selected option into a table (MacroAdds). Now based on check boxes next to each Data Validation list I want to be able to filter the table below by clicking another button (I assume where the code will need to go). My check boxes cell links are in E3:E6 and I want to be able to say that if any of those are TRUE, the table will filter each column to display only the checked results in C3:C6.
I do not know macros well at all but I think because my table is meant to expand based on my button that my range for this filter will always be changing and do not know how to overcome that (currently table is A13:L33).

See More: How to filter table based on cell if a checkbox is selected

Report •

June 3, 2016 at 03:28:39
Without actually seeing the workbook we cannot help, it is not feasible for me to recreate your workbook as I have no idea how it is setup, if you want you can email your workbook to me, removing sensitive data and I can have a look at it. if you want to email it, please PM me your email address and I will follow with an email to that address.

Report •
Related Solutions

Ask Question