updating pivot table with dynamic source data VBA

[spq24]

I need to update a pivot table every day and the source data (a data dump from a company system) grows each day. I need to the source data to grow each day with it using vba code. Is this possible?

 

[taurean]

It will help if you post:
1. Sheet that contains data showing Column layout
2. Pivot Layout
3. And the version of Excel you are dealing with!

And you can remove sensitive info and use dummy data.

 

[spq24]

I can't post the sheet right now because it involves sensitive data but There are three pivot tables one has data in columns A:U and down to row 282 in sheet 1 right now and that will grow significantly as the year goes on and then go back down at the beginning of next year and I'm using excel 2007.

The second has data in column A:U and down to row 8 right now but that will fluctuate.

and the third is columns A:U down to row 59 but that will fluctuate

 

[taurean]

I do not see any harm in posting dummy data. Anyway, with this information I'm afraid, I'll be of little help. Maybe then you should take a look at the following link:
http://vbadud.blogspot.com/2008/05/create-pivot-table-using-excel-vba.html

Try to create the code based on this and then probably we can work it out!