Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Date criteria
Hi All
I want to put some criteria on "Date" field of my pivot table by VBA. Something like = Today(). Is it possible at all ? Or should I organise my datalist before Pivot accordingly? Or should I copy my pivot report elsewhere and loop afterwards ? Any idea ? Thank you very much in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Date criteria
Done it.Works great.
Thank you Jim. Jim Thomlinson wrote: Add an extra column to your source data with pretty much that exact formula in it. You can drag that field to the filter section of your pivot. Each day just refresh the pivot table... -- HTH... Jim Thomlinson " wrote: Hi All I want to put some criteria on "Date" field of my pivot table by VBA. Something like = Today(). Is it possible at all ? Or should I organise my datalist before Pivot accordingly? Or should I copy my pivot report elsewhere and loop afterwards ? Any idea ? Thank you very much in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table criteria | Excel Discussion (Misc queries) | |||
Pivot - can we set criteria? | Excel Worksheet Functions | |||
how to i pivot a table using various criteria | Excel Worksheet Functions | |||
pivot tables criteria vba | Excel Programming | |||
Date range criteria and Pivot tables (again!) | Excel Worksheet Functions |