Selecting Date Range in a Pivot using VBA

G

Gaura215

I have created a pivot table, which has a date field in report filte
field.

I need to prepare this Pivot every month. Is it possible, that whil
preparing this PIVOT using VBA, something can be done that the pivo
automatically selects the dates only from the previous month and do no
show all dates in the pivot.

For example, this month I prepared the report for the month of may. So
want the pivot to automatically show the data from may month and not th
all months data. I have copied below the table below which I prepared.


Date Logged (All)
Status (All)
Country (Multiple Items)

Count of Tick mark when_x0020 Column Labels
Row Labels 0 1 Grand Total
High 89 8 97
Low 93 2 95
Medium 98 4 102
Grand Total 280 14 29
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VBA on Excel Pivot Tables 3
Adjust Pivot Table Filter based on a Range 0
Wanted to show 12 month Date in Pivot table 2
Assistance need to populate "GRAND TOTAl" "MSpivottable11" in Microsoft web component 0
Excel 2007 VBA Pivot table fetch records 0
MS Excel VBA Pivot table link cell fetch records 1
Can I Sort (A-Z or Z-A) Pivot Table Data or Fields using VBA? 4
Summarsing Variable Pivot Table Data 1

Top