+ Reply to Thread
Results 1 to 3 of 3

how to make pivot table auto filter which is source data

  1. #1
    Forum Contributor
    Join Date
    12-14-2016
    Location
    UAE
    MS-Off Ver
    MS OFFICE 2016 & 2019
    Posts
    154

    how to make pivot table auto filter which is source data

    hello,

    i searched many site and forums but i couldn't find the correct solution yet. i have a table and two macros which is reference with months based on filter and i have a another sheet of pivot table if i select the months of filtering using macro and i run the source data is filtering but same time pivot table in other sheet its not filtering same time and i have to do manually in pivot chart then upfdating to pivot table and i have also main table has protected sheet if i click refresh button its cant be refresh on protected sheet so many of them struggle for this problems pls anyone can help to sort out this problems.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,067

    Re: how to make pivot table auto filter which is source data

    Hi I think your question belongs in the VBA Macros section.

    You may get a better chance of responses.

    Cheers
    Remember you are unique, like everyone else

  3. #3
    Forum Contributor
    Join Date
    12-14-2016
    Location
    UAE
    MS-Off Ver
    MS OFFICE 2016 & 2019
    Posts
    154
    Quote Originally Posted by noboffinme View Post
    Hi I think your question belongs in the VBA Macros section.

    You may get a better chance of responses.

    Cheers
    Maybe I'm looking for better solution even in any other ways

+ 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. Pivot Table Auto Update Data Source?
    By Ket in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-20-2020, 02:05 PM
  2. Changing Pivot Table Source Data w/ Filter Controls
    By seethesun in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-06-2016, 02:21 PM
  3. Auto-Refresh Pivot Table When Source Data Refreshes
    By XLINT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2015, 11:00 AM
  4. [SOLVED] Auto Refresh Pivot Table Once External Data source Changes
    By djfatboyfats in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2012, 10:33 AM
  5. Replies: 2
    Last Post: 11-02-2012, 10:38 AM
  6. how to make my custom formula in OLAP data source pivot table?
    By Abobakr_Nasr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2006, 07:00 AM
  7. [SOLVED] Can I set a filter on the source data for a pivot table
    By ChrisP in forum Excel General
    Replies: 2
    Last Post: 08-29-2005, 05:05 PM

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