+ Reply to Thread
Results 1 to 2 of 2

Using vba to change pivot table filter based on cell value in another worksheet

  1. #1
    Registered User
    Join Date
    04-04-2013
    Location
    Solihull, West Midlands
    MS-Off Ver
    2010
    Posts
    19

    Using vba to change pivot table filter based on cell value in another worksheet

    Hi All,

    First post here. I have posted a similar problem on the mrexcel forum which can be found here....

    http://www.mrexcel.com/forum/excel-q...ell-value.html

    What I am trying to achieve is to automatically update a pivot table ("PivotTable 3 which is in a sheet called "T5") based on cell D2 in a sheet called "Report". The only values that will appear in D2 will be the numbers 1-13, with the pivot table filter containing the same, so for example when I change the value in D2 to 1, I'd like the pivot table filter to change to 1.

    Can anyone help with this? My knowledge of VBA isn't that good (still learning!) so any help would be greatly appreciated!!!


  2. #2
    Registered User
    Join Date
    04-04-2013
    Location
    Solihull, West Midlands
    MS-Off Ver
    2010
    Posts
    19

    Re: Using vba to change pivot table filter based on cell value in another worksheet

    Hi All,

    I've found a solution to this that was so simple can't believe I missed it!!!

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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