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