Results 1 to 6 of 6

Add Pivot Table Filters to current UserForm code.

Threaded View

  1. #1
    Registered User
    Join Date
    04-08-2014
    Location
    usa
    MS-Off Ver
    Excel 2011
    Posts
    52

    Add Pivot Table Filters to current UserForm code.

    Hi,

    I am trying to utilize my current code to also add a filter to a Pivot Table field. Currently the code filters the worksheet, but now I need to filter the pivot table to provide data analysis through charts/graphs.

    I need to be able to do both, filter worksheet and filter pivot tables.

    I have uploaded an example version and screen shot to give an idea.

    I appreciate all the help in advance. I've made so much progress thanks to many of the forum contributors.

    Thanks!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Darkenergyz; 04-16-2014 at 03:31 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using two filters on a Pivot table
    By huckzors in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 04-22-2013, 03:59 PM
  2. Replies: 1
    Last Post: 02-22-2012, 12:21 PM
  3. Change pivot table filters on VBA userform combox box change?
    By Teemu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2011, 05:49 AM
  4. VBA for Pivot Table Filters
    By Coldsteel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-28-2010, 09:03 AM
  5. VBA Code for a pivot table to open database and to reference table current page
    By Pete Straman Straman via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2005, 12:06 AM

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