Hello,
I have a code that automatically updates my pivot tables based on the new data I put into a spreadsheet every month. I filter these pivot tables to show only data from the current month. Is there a way to include this in my VBA?
For example:
I have data from January-June. The pivot tables are currently filtered to show June data. I just added July. I run my macro and then have to manually change the filter to July.
Thank you!
Please Login or Register to view this content.
Can you record a macro where you manually change the filter to July and post the code here.Originally Posted by eskyec
Hello,
I have a code that automatically updates my pivot tables based on the new data I put into a spreadsheet every month. I filter these pivot tables to show only data from the current month. Is there a way to include this in my VBA?
For example:
I have data from January-June. The pivot tables are currently filtered to show June data. I just added July. I run my macro and then have to manually change the filter to July.
Thank you!Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Yes, thank you for your help
Please Login or Register to view this content.
This will select the last month in the Month field list.
Please Login or Register to view this content.
what if the button to run the macro is on a different page. It worked when I was on the pivottables sheet but I run the macro by clicking a button on the final results sheet.
it has a problem with thePlease Login or Register to view this content.
Sorry! I have it figured out!!
I have another question though. how can i make is reference a value in a cell.
for example I can type "May" into a cell and it will then sort the pivot tables by may.
Change this...
.CurrentPage = .PivotItems(.PivotItems.Count).Name
To something like this. Change the sheet name and range to suit.
.CurrentPage = Sheets("Sheet1").Range("A1").Value
Thank you very much for your help! Works like a charm!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks