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?
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?
