+ Reply to Thread
Results 1 to 1 of 1

Macro to filter a pivot whilst looping through filter criteria in a variable list.

  1. #1
    Registered User
    Join Date
    05-29-2015
    Location
    Birmingham UK
    MS-Off Ver
    2010
    Posts
    8

    Macro to filter a pivot whilst looping through filter criteria in a variable list.

    Hello.

    Firstly I will try give some background on what I'm trying to achieve and hopefully it will make sense...

    In my data I have a set of 'programme names' that when selected by a user, needs to filter my pivot tables/charts. Not all programmes will need to be viewed in the pivot, but if multiple programmes are selected by the 'user' I need to filter the pivots for each one. (Each time the filter is applied I have auto-updating charts in a PowerPoint that I will then need to screenshot and save as a snapshot for that programme)

    Firstly, a user will select which programmes they wish to run reports for, using a slicer on a front page. This slicer then filters a pivot to create a list of selected programmes. This will be the list of programmes I wish to loop through to filter the other charts/tables.

    So please could anyone help with the macro to loop through the list of 'programmes' to filter my pivots. The list will be of variable length. Also I would need the macro to filter first, perform an action (screenshot the power point slide and save into a fresh presentation - but i will worry about how to do this later!)


    I.e if my list is in range A1:A12 (could be longer or shorter) and I need the pivot to filter to each value in this list one at a time)

    Hopefully that makes sense.

    Many Thanks

    Alistair
    Last edited by Alistairm88; 05-29-2015 at 05:12 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. looping through pivot table filter
    By ShaliniGomes in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-25-2014, 12:02 AM
  2. Looping a pivot filter change & sending via email
    By johnoc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2014, 10:11 AM
  3. Pivot Table, Looping through Filter
    By noobtime in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2013, 05:53 PM
  4. How to set Filter Criteria in Pivot with Macro?
    By cathchin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-08-2012, 09:41 PM
  5. Looping filter criteria
    By VBA Noob in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-13-2006, 01:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1