Pivot table Filter update through VBA code

Dear Friends,

I have a database for which i made a pivot table for report purpose.

in pivot table, i have some raw heads & values . And mainly in report filter, invoice received date.

In i need to prepare a report weekly. i have StartDate & EndDate in excel, need to update pivot table by filtering only those dates which comes under the start date and end date. or else RptDt1, RptDt2, RptDt3, RptDt5, RptDt5.

i haves some code, its not working properly, please help.

Please Login or Register  to view this content.

Thanks in Advance,
Suresh

Hi... Oeldere... thank you for your suggestion, the pivot table is not my report, i am getting my report through this pivot,

i mean, there are some more work to be done, like dashboard update, making charts related weekly figure, all i am doing through macro only, i stuck with this portion... if possible, i want this to be automated.