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?
Any thoughts on how I can make this work?