Hi there.
I'm new to autofiltering and writing VBA code so please be patient with me.
I have 2 worksheets. The first worksheet contains a table, whilst the 2nd worksheet contains 'filter options' for that table.
I want to be able to use some simple 'checkbox' style cells that have either a value of 0 or 1 so that when I run a macro, it will autofilter the table to include/disclude rows corresponding to those 'boolean cells' values.
I have attached my workbook to show you what I mean.
(In this workbook the 'Filter' worksheet has a number of green and red circles, which just amount to 1 or 0 values. I want to have a macro assigned to a button on the filter page which alters the table on the other page so that the table hides away any rows which contain the relevant Filter strings).
Any help is much appreciated.
Thanks
Xander
Bookmarks