Can I... (trying to be clever with pivot tables)

tazeo

tazeo

Joined
Feb 14, 2007
Messages
5
Reaction score
0
Hi All
I think this is possible, but I can't find a definite Sample of code to do so.

I want to have a pivot table to auto generate (which I can do) but I want it to dynamically change the between dates, which would be referenced elsewhere in the workbook. Basically I need to automatically create a table that is for the last 3 months, one for the last 12 months, and one for financial year (jul-Jun).

Am I delusional, or can it be done.
 
Last edited:
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can set dynamic pivot table ONLY when I have enough data point 1
Link Drop Down list with Pivot Table 3
Link Drop Down list with PIVOT Table in Excel 2003 0
Wanted to show 12 month Date in Pivot table 2
Pivot table code question 2
Using VBA on Excel Pivot Tables 3
modified pivot table using a macro 2
refresh multiple pivot tables in workbook 2

Back
Top