PDA

View Full Version : VBA Excel - Filter over filter using buttons



Cristy0505
10-02-2013, 05:49 AM
10650

Hello!

I have the worksheet attached.

Second sheet called "DATABASE" is from where I want to retrieve the datas from.

First sheet called "FILTER" is where I want the filtered results will be displayed.

There are the buttons by Supplier name where I want results taken from worksheet "DATABASE" be shown on column called "Supplier" on sheet "FILTER". Next I would like by clicking on month buttons (january, february, etc) be filtered by month (in this step it should be displayed like this: Supplier > Month ) then next filtered again by this month week (see worksheet "DATABASE").

Could somebody help me out on this?

Thanks in advance!

Beavisx
12-19-2013, 07:24 AM
Uhm,.. I did't understand 100% your objective, hovewer my suggestion would be to try with using a Pivot Table

Have you tried yet?