Most valuable professional
  • Hot Topics

Excel Filter only results in the next 28 days from Pivot Table using VBA

Hi, I am looking to filter my table to show only the data from the next 28 days, I tried using the below but it returned an error. Included full example below pt.PivotFields("Dates").PivotFilters.Add Type:=xlDateBetween, Value1:=Today(), Value2:=Today() + 28 Sub PTFour() Sheets.Add ActiveSheet.Name = "x" Dim pt As PivotTable Dim strField As String Dim WSD As Worksheet Set WSD = Worksheets("Raw Data") Dim PTOutput As Worksheet Set PTOutput = Worksheets("x") Dim PTCache As PivotCache Dim PRange As Range ' Find the last row with data Dim finalRow As Long finalRow = WSD.Cells(Application.Rows.Count, 1).End(xlUp).Row ' Find the last column with data Dim finalCol As Long

This question generated 32 answers. To proceed to the answers, click here.

This thread is current as of September 15, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel