automated pivot table

[cahickm2]

I need help with automatically creating a pivot table when information is placed onto a work sheet. example: I place information on sheet 1. and a pivot table is automacticall created on sheet 2 with the columns desired.

 

[xenou]

Start by using the macro recorder to record the code, then edit if needed. You could try recording the code to select the data area first by using Ctrl + Shift + Spacebar to select the current region (in code: Selection.CurrentRegion.Select). Then record Data | Pivot table and pivot Chart ... etc.

To be honest, it only takes three clicks to create a pivot table (Data | Pivot Table and Pivot Chart | Finish). Do you really need a macro? Anyway, my experience with pivot table macro's is that they aren't worth all the work as the code is rather long to do something that is very easy in native Excel.

This will give you the flavor:
http://www.brainbell.com/tutorials/Excel_VBA/Create_Reports_For_Each_Region_Or_Model.html

and these books cover pivot tables:
http://www.amazon.com/Crunching-Microsoft-Office-Business-Solutions/dp/0789736012

http://www.amazon.com/Macros-Micros...6969613?ie=UTF8&s=books&qid=1185406958&sr=1-3

Regards.