Macro to filter pivot table

isixdos1

Board Regular
Joined
Jan 19, 2009
Messages
57
How can I code a macro to filter a pivot table for a specific date? I am running a pivot table and changing the date filter to the prior day each day to review the recorded data from the day before. Since this is a redundant task I would like to automate it.
Any thoughts on how I can make this work?
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,109,165
Messages
5,527,179
Members
409,750
Latest member
BorisYeltsin

This Week's Hot Topics

Top