Pivot Table refreshing on a dynamic range of data

[t16turbo]

Hi there,

I have a worksheet, 'Pivot', containing a pre-defined pivot-table.
I also have a worhseet called 'RawData'
containing data refreshed by a macro - so the number of rows can change.
There are 14 columns of data.

I need to be able to refresh the pivot-table using the complete range of data each time it is run.

can anyone show me how this is done? - or show an example of one you have done previously.

thanks for your help

 

[xlbo]

Have a look here:

How can I rename a table as it changes size faq68-1331

base the pivottable on the dynamic named range

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question