Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table
Hi; I have very large datas in column A & B. To get what I need, I create PivotTable. But I have to do that manually each time the datas in bot columns changed (on a daily basis). Is there anyway that I create the PivotTable once, and the datas i this pivot table will be updated automatically each time the datas i column A & B changed. Can I setup a macro to run the pivot table? I would appreciate for any help. go4cd -- go4cd ----------------------------------------------------------------------- go4cdt's Profile: http://www.excelforum.com/member.php...fo&userid=3258 View this thread: http://www.excelforum.com/showthread.php?threadid=52536 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table
Hi,
There are two questions in your post : 1. The input data ... the solution is to Insert Name Define a dynamic range ... so you will not have to worry about the input data 2. The PivotTable refresh ... pivottable.refresh can be written in an event macro, ideally your working sheet ... worksheet calculate event ... all refresh will be automatic ... HTH Carim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table
My datas in column A are changed daily and are not constant in value so I can't really use the Insert Name Define solution. The pivot table refresh solution seems to fit my needs better, but I have no idea of how and what to do with that. More help please Thanks -- go4cdt ------------------------------------------------------------------------ go4cdt's Profile: http://www.excelforum.com/member.php...o&userid=32580 View this thread: http://www.excelforum.com/showthread...hreadid=525362 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table
You dont say where the data comes from or how it gets into your spreadsheet. If it is in a database then you can use Pivot Table wizard step 1 of 3 to slect the radio button to get the data from an external data source. That can directly from a database storing the information or from another spreadsheet where you have stored the information. In either case you do not have to redefine the data range .. it will just get everything that is there that meets any criteria you have entered in the 'get data' process. Set the pivot table to refresh automatically when you open the spreadsheet if you want. regards.. -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=525362 |
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) | |||
Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
Copying values from pivot table to cells outside 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 | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |