Pivot table

[go4cdt]

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

 

[Carim]

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

 

[go4cdt]

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

 

[steven1001]

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..