show report filter pages , pivot table

saro1975

New Member
Joined
Oct 12, 2018
Messages
1
Hi,
I hope that i can explain my problem.

I have a pivot table, for every change in item in this pivot table excel creates a new worksheet, with the function 'show report filter pages'.

So i have like 40 worksheets created. Now i want a cell in every created worksheet with a date in it. But in every worksheet created with the function 'show report filter pages' the date has to go up with 1 day. So the date of sheet2 = +1 day, the date on sheet3 = the date of sheet2 +1 day, the date of sheet4 = the date of sheet 3 + 1 day etc etc.

Iam stuck here because the amount of created worksheets will be different every time depending on the pivot table.
Can this be done in vba?
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Watch MrExcel Video

Forum statistics

Threads
1,109,250
Messages
5,527,635
Members
409,778
Latest member
MagalieD

This Week's Hot Topics

Top