Can we create pivot table dynamically

B

Bob Flanagan

Sure. Use the macro recorder to get the code. Tools, Macro, Record Macro.
Be prepared to do modifcation to the result.to make it useful. For example,
Excel records the range of data that you have. If you later expand the
data, then the code is not right.

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
T

Tom Ogilvy

If you mean define the range for a pivot table source, it would be easier to
use a Defined name as a source and have the defined name built with formulas
that establish the breadth and width of the source data.
 
Top