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