Pivot table fields update

[need2kno]

I operate Excel 2010 and have a database on a sheet comprising budget, last year and current year data under each other. columns to right comprise april through to march (12 columns).Budget and last year have data in each of twelve columns, but current builds each month.
Each month five (so far - will increase as workbook is used) pivot tables / charts are updated to give sales people info.
Problem is dynamic formula pulls data into each table but I have to go into each individually and drag the new month into the table (some tables show each of the twelve months but others show current month only. Can it be done automatically? Pivot table field list generally comprises top ten subjects such as region, product, customer etc. but some tables have fields with last two items comprising Apl and May (2 years to date so far); others are last 12 items comprising twelve months apl to mar (picking up budget and year-to-date in layout.

 

[TheBaron26]

Hi need2kno,

I have a very similar problem, although I'm using 2007. I need to dynamically populate the date field in a pivot table according to the most recent date. I have some vba code to set up the table but I have to manually enter all the dates I want it to populate. I was wondering if the "Today" formula could be used in the vba code to update the pivot dynamically but haven't found an answer yet.

If I find anything I'll post something here.