Can we create pivot table dynamically

  • Thread starter Thread starter priya
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can set dynamic pivot table ONLY when I have enough data point 1
Unable to Group in Pivot Table 1
DYNAMIC RANGE FOR PIVOT TABLE 1
how to count columns i pivot table? 1
dynamic pivot table selection 1
Pivot Table Criteria Missing Data 4
Wanted to show 12 month Date in Pivot table 2
Excel 2010 Pivot Table 2

Back
Top