Dynamic pivot table structure

[Cferron]

Hello all,

I would like to know if it is possible to get a column added automatically in a dynamic table. I explain with images.
I have columns with dates. These are not yet in a pivot table ,but every day the header changes based on today's date.

The data in these columns are put in a pivot table but when a date disappears in the sheet, so it does in the pivot table (this is fine).
However I was hoping the pivot table could automatically add the new column with a new date at the end.

Is there a way this can be achieve in Pivot table?

Hope this is clear enough.

Thanks

 

[BSALV]

isn't it easier to have header like today, today+1, today+2, etc.
This days don't change, so no problems for the pivottable.
Above the pivottable VBA pastes a new adapted header with the real values of today, etc.

or

is that date a column in your sourcedata and with a slicer you can choose between today and today+9
Can you show 1 or more lines of the sourcedata ?

 

[Cferron]

isn't it easier to have header like today, today+1, today+2, etc.
This days don't change, so no problems for the pivottable.
Above the pivottable VBA pastes a new adapted header with the real values of today, etc.

or

is that date a column in your sourcedata and with a slicer you can choose between today and today+9
Can you show 1 or more lines of the sourcedata ?

Thanks, I think Option A would perfectly fit my need. Thanks for putting brain power into this!