It's not clear what you're doing, but perhaps you could turn on the
macro recorder while you run the wizard on one worksheet, and make the
changes.
Then, run the recorded macro on a copy of another sheet, to see if it
works the way you want.

Rob B wrote:
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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html