Problems with "homemade" autofilter buttons

To view both the quarter together and in assending order use this code.

Please Login or Register  to view this content.

Originally Posted by kvsrinivasamurthy

To view both the quarter together and in assending order use this code.

Please Login or Register  to view this content.

Thanks for the fast reply. Maybe I was not quite clear on what i want.
I want buttons named "Qaurter 1", "Qaurter 2", "Qaurter 3" and "Qaurter 4". I want to make it possible to push the "Qaurter 1" and "Qaurter 3" button, and then only show these 2 quarters.

At the moment if I press 2 buttons, it will only view the last prest button fx. Quarter 4.

Originally Posted by JosephP

what should happen if you press three buttons?

I want to show the 3 selected on my sheet?

Imagine you got:
january
february
march
april
may
etc

On the autofilter you can select january, march and may with checkboxes.
I want to make a "feature" like this, where you can press 2 buttons which shows the pressed buttons criteria.

Originally Posted by JosephP

figured you'd say that - makes it harder ;-)
can you post a sample of the data you are using? the code will have to be quite specific since Excel's own autofilters couldn't do what you want.

Yes I will try that tomorrow since I'm not at my workstation atm I will make a simple example to make it easier to understand.
The last thing i tried was to bind some text strings to the buttons, and by IF sentences push them into the autofilter and see if that's possible.

The main problem is I want to make a "grocery list" with selections, and then send them away at the same time. It would be a lot easier of i know to commands a prior.

Originally Posted by JosephP

I reckon you're probably going to need to filter with an array of values to get what you need instead of using greater than and less than criteria.

Even though i know that I only got 4 different buttons?

It must be possible to do with IF sentences? There must be a way to check what filter is on, and then choose another?

I've made an attachment now with some data.

At the moment you can push a button and it shows the correct data. I want to make it possible to push 2 buttons and show the data from both criterias.

Test_Autofilter.xlsm

I kind of found a solution but it will take 64 if statemens (4^2) which is not usefull and 2 complicated. So i really hope someone got a better solution

Originally Posted by JosephP

I'd use an advanced filter and some checkboxes like this.

That's actually a very good solution. How did you make that? It looks pretty simple.

Is there more than the code in K2 and the setFilters and clear in VBE?

Originally Posted by JosephP

there's a formula in J2 that looks at which checkboxes have been set (the checkboxes are linked to the cells under them but those cells are formatted to hide all data) but other than that it's just the criteria range and the code you see.

Thank you. I will use this solution i think