|
|
#3
02-27-2017, 11:21 AM
|
|||
|
|||
There is no macro yet so I can't upload it.
There is a pivot table. When you double clicking on the “Grand_Total and “Grand_Total” cell in a pivot table a new sheet is created containing the data from the pivot table. Part of my question is how to handle the issue of every day the pivot table creates a sheet of data it uses a different name. Perhaps you can create a pivot table to see what I am talking about. 
|
|
|
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