Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can we create pivot table dynamically
Can we create pivot table dynamically through coding in vb
-- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can we create pivot table dynamically
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 "priya " wrote in message ... Can we create pivot table dynamically through coding in vba --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can we create pivot table dynamically
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. -- Regards, Tom Ogilvy "priya " wrote in message ... Can we create pivot table dynamically through coding in vba --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
how do i link to a pivot table to get data dynamically | Excel Worksheet Functions | |||
pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Dynamically changing a calculated field in Pivot Table | Excel Programming |