Need Help Macro That Uses Pivot Table to Create New Sheet
I am trying to write a macro to automate a process that happens every day.
Every day a pivot table gets some new data which is manually refreshed. This pivot table creates a new sheet by the user double clicking on the “Grand_Total and “Grand_Total” cell. I need to delete the old sheet created yesterday, create a new sheet using today’s data then rename my new sheet all inside my macro.
How do I do this?
Thanks.
|