Consulting

Results 1 to 2 of 2

Thread: VBA Excel - Filter over filter using buttons

  1. #1

    VBA Excel - Filter over filter using buttons

    TEST - BILLING MAP.xlsm

    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!

  2. #2
    VBAX Regular Beavisx's Avatar
    Joined
    Dec 2013
    Location
    Lugano
    Posts
    9
    Location
    Uhm,.. I did't understand 100% your objective, hovewer my suggestion would be to try with using a Pivot Table

    Have you tried yet?
    Sorry about my English mistakes!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •