You can record the steps as you manually create a pivot table. There are
instructions and links on Jon Peltier's web site:
http://www.peltiertech.com/Excel/Pivots/pivotstart.htm
tranfer data into pivot table??? wrote:
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html