|
|
#6
02-28-2017, 08:15 AM
|
|||
|
|||
NoSparks.
Using the macro recorder is what I started doing. The problem is every time I double click on the “Grand_Total and “Grand_Total” cell When it creates the new sheet it gives it a different name. The next steps in the macro need to get the data from this newly created sheet. Tough to repeat when it is always a different name! When I click on the sheet with the pivot table in it, right click and select view code there is no code there. Pecoflyer The pivot table normally doesn't change, only on rare occasions. The data in it every day does change. 
|
|
|
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