+ Reply to Thread
Results 1 to 2 of 2

Update Filter Pivot Table from Cell value

  1. #1
    Registered User
    Join Date
    05-15-2019
    Location
    São Paulo
    MS-Off Ver
    365
    Posts
    8

    Update Filter Pivot Table from Cell value

    I´m trying looking for here but at now i did not.
    I have a pivot table (named Tabela) with 2 columns: Orders Code and Days to Execution (number of days)>
    I need a VBA code that filter my Pivot table according the value number in a external cell. This number could be <, > or = Column "Days to Execution".
    I founded several Vba codes but with text value in a cell reference, this don´t help me.

    Thank you so much !

    Paulo Cezar

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,540

    Re: Update Filter Pivot Table from Cell value

    I don't know enough about VBA to say whether or not this is possible, however it may help if you upload a small desensitized sample file that shows some raw data for the pivot table, the pivot table before filtering and then a manually filtered version of the pivot table so that VBA forum contributors will have a better idea of what you are attempting to accomplish.
    To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 1
    Last Post: 02-25-2018, 09:47 PM
  2. Two pivot tables with the filter of pivot table 2 to automatically update to filter 1
    By StefaniaLa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2018, 06:19 PM
  3. [SOLVED] How to get pivot table filter options to update?
    By Slurry Pumper in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-12-2016, 08:45 AM
  4. VBA to update Filter by Color in Pivot table by cell value/color
    By bhenlee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2015, 05:56 PM
  5. Update Filter several Pivot Table by day
    By l.niehues in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2014, 10:04 AM
  6. Update a pivot table filter based on an input in a cell in a different sheet
    By Benoj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2014, 11:37 AM
  7. Pivot table Filter update through VBA code
    By way2suresh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-01-2013, 08:48 AM

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