Hello - Any chance anyone has some code available that would allow me
to create a pivot table for a range of data that changes?

I run the pivot by grouping the same fields in the table, but the
number of rows in the data set is different each day.

Thanks for any help you can provide.

Even if the code doesn't fix my problem exactly, it will still be nice
to see what code you have available, so that I can learn from it.

Thanks!

If you use a dynamic range for the pivot table source data, or a List in
Excel 2003, or a Table in Excel 2007, all you need to do is refresh the
pivot table by clicking on the "!" button. No code needed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Mike C" wrote in message
...
Hello - Any chance anyone has some code available that would allow me
to create a pivot table for a range of data that changes?

I run the pivot by grouping the same fields in the table, but the
number of rows in the data set is different each day.

Thanks for any help you can provide.

Even if the code doesn't fix my problem exactly, it will still be nice
to see what code you have available, so that I can learn from it.

Thanks!