Hi i would like to get invloved with automating pivots.

I suppose it might be better to automate parts of the process at first and
then work into full-automation ( comments welcome)

The first thing I thought of was a macro to assign to a button to launch
pivot dialog, build on external new sheet, and take me to the layout section
of the build process so I can pick fields.

Can this be done in a macro.

what is the best way to learn about pivot process interaction and macro
building related to pivots.

Thanks Todd