| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatically assigning pivot based on unknown range?
I have a number of sheets with potentially up to 60000 rows and 5 columns (this is not always the case). I want to be able to automatically set a pivot table for each sheet. Along the column row would be the variable "ReportType", the colum would be "Value" and the count would be of "ID". I hope this makes sense, let me know if it is not possible. Many thanks Amy x -- AmyTaylo ----------------------------------------------------------------------- AmyTaylor's Profile: http://www.excelforum.com/member.php...fo&userid=2097 View this thread: http://www.excelforum.com/showthread.php?threadid=53977 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning a Number Based on a Range. | Excel Worksheet Functions | |||
| Assigning a Number Based on a Range. | Excel Worksheet Functions | |||
| Sorting based on the first column of a defined name range (Unknown) | Excel Programming | |||
| Automatically Assigning a Macro to a button | Excel Programming | |||
| Automatically Assigning a Macro to a button | Excel Programming | |||
![AmyTaylor[_60_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
