Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Automate Date field in pivot table using macro RRS feed

 > 

  • General discussion

  • Discussion
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have an Excel sheet consisting of Pivot table and it has Date field with name "AsAtDate" coming from SSAS 2000 dimension, I need  to write a Macro which automatically select the Date field of Pivot table in excel to 2 days prior to today's date. Appreciate the early response, thanks in advance...

    • Changed type qadir756 Wednesday, December 21, 2011 5:45 AM It would not come under Fix it centre
    Wednesday, December 21, 2011 4:56 AM