|
|
#1
02-27-2017, 05:19 AM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How do I create a report that works like a pivot table but does not calculate values
|
elizbeth6339 | Excel | 1 | 03-09-2016 07:14 AM |
| extract specific pivot table data to a new sheet | theexpat | Excel Programming | 0 | 02-18-2016 10:08 AM |
|
Create PIVOT chart using few rows in pivot table
|
Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
| How to create a pivot table with text as values | ljd108 | Excel Programming | 0 | 01-22-2015 07:48 PM |
|
VBA: Include Dynamic Sheet Name In Pivot Table Source Data
|
ibrahimaa | Excel Programming | 2 | 04-28-2012 12:27 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode