I am cleaning Excel worksheets for input into another program (Recorder 6). I
have found a routine involving pivot tables which does the best job, however
I need to run the wizard for each new sheet. Is there a way of saving the
pivot table layout & then simply run it for each new workbook?

There are usually 100 columns of up to 10 rows (after a transition) involved
here, each of which apparently needs to be manually edited (from 'count of'
to 'Sum of' ) in order to work.

Cheers now, Rob