Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I run a macro to create a pivot table?
Each week I get a report in columns with varying Nos. of rows of info.I would
like to create a macro to automaically create and format a Pivot Table in the manner in which I would like to see this info. Is this possibleto create a macro to do this as I seem to come up with errors when I run a macro on a new report. Thanking You. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I run a macro to create a pivot table?
Hi
You could just create the Pivot Table once and save your file. Make the data range a dynamic range rather than fixed cell references. Each week, you could just paste the new data and append it to the bottom of your table, or overwrite everything below the header line and Refresh For more information on Dynamic Ranges (and Pivot Tables), take a look at Debra Dalgleish's site. http://www.contextures.com/xlNames01.html#Dynamic http://www.contextures.com/xlPivot01.html -- Regards Roger Govier "Eqa" wrote in message ... Each week I get a report in columns with varying Nos. of rows of info.I would like to create a macro to automaically create and format a Pivot Table in the manner in which I would like to see this info. Is this possibleto create a macro to do this as I seem to come up with errors when I run a macro on a new report. Thanking You. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I run a macro to create a pivot table?
Thanks Roger
"Roger Govier" wrote: Hi You could just create the Pivot Table once and save your file. Make the data range a dynamic range rather than fixed cell references. Each week, you could just paste the new data and append it to the bottom of your table, or overwrite everything below the header line and Refresh For more information on Dynamic Ranges (and Pivot Tables), take a look at Debra Dalgleish's site. http://www.contextures.com/xlNames01.html#Dynamic http://www.contextures.com/xlPivot01.html -- Regards Roger Govier "Eqa" wrote in message ... Each week I get a report in columns with varying Nos. of rows of info.I would like to create a macro to automaically create and format a Pivot Table in the manner in which I would like to see this info. Is this possibleto create a macro to do this as I seem to come up with errors when I run a macro on a new report. Thanking You. |
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 create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
create pivot table from excel table | 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 |