I've got a spreadsheet in my Excel 2010 workbork with a lot of data. This page can be sorted by the build in autofilter. On another sheet I have made a button which do some of the sorting. FX:
When I do this the sheet shows the second quarter of the year. I've got a button which show the third quarter of the year which looks like this:Please Login or Register to view this content.
My problem is: When I press the first button (Second quarter) it filters and show the second quarter. But when I press the "Third Quarter" button it removes the Second Quarter filter and views only the Third Quarter.Please Login or Register to view this content.
Is it possible to write some kind of VBA code which make it possible to have both button pressed at the same time, like it's possible to do with the build in autofilter buttons?
If you're not quite sure what I mean, please ask for better explanation.
Thanks in advance
Bookmarks