automating a process in pivot tables
 

Hello everyone, hope you can help with this one:

I have a pivot table with a number of fields and a layout with shows a
cross tabulated aggregated view.

I have fields called DirectorateDesc and SpecialtyDesc which have x
number of possible values.

I need to run thru each DirectorateDesc and the possiible SpecialtyDesc
values for each DirectorateDesc and copy the pivot-table results into
new sheets every week and would like to automate the process if
possible.
The new sheet name would be the combed name in the value in the
DirectorateDesc and SpecialtyDesc field.

Does anyone know how I can automate this ??
Many thanks for your help
AMy xx


--
AmyTaylor
------------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
View this thread: http://www.excelforum.com/showthread...hreadid=552274