Hello,
I am hoping to get some much needed assistance with automating a pivot table creation process I use each week. Each week I need to create a report showing the activity for the week previous. Using a database output (and much help from this forum
) I am able to macro the preparation process all the way up to creating a pivot table. I have tried using the macro recorder to do this but it does not work when I run the pivot table macro created via the recorder. I am hoping to be able to try coding the pivot table without using the recorder. The source data table for the pivot table is named data. What I would like to be able to do is:
1) In the filter box, select the days for the current week from the date field (the current week goes from Monday to Sunday (i.e.-6.6-6.12)
2) In the Row labels box, place a field called TypeofEvent
3) In the count box, place the TypeofEvent
I greatly appreciate any help that may be provided.
Take Care,
Skip
I am hoping to get some much needed assistance with automating a pivot table creation process I use each week. Each week I need to create a report showing the activity for the week previous. Using a database output (and much help from this forum
) I am able to macro the preparation process all the way up to creating a pivot table. I have tried using the macro recorder to do this but it does not work when I run the pivot table macro created via the recorder. I am hoping to be able to try coding the pivot table without using the recorder. The source data table for the pivot table is named data. What I would like to be able to do is:1) In the filter box, select the days for the current week from the date field (the current week goes from Monday to Sunday (i.e.-6.6-6.12)
2) In the Row labels box, place a field called TypeofEvent
3) In the count box, place the TypeofEvent
I greatly appreciate any help that may be provided.
Take Care,
Skip
