Autogenerate end of month pivot table

[mtsykes28]

I want to be able to create a pivot table at the end of every month that is automatically generated. All the data for the pivot table will be on a single spreadsheet. The format will stay the same every month however the emphasis is on it being generated automatically on the very last day of the month vs the current procedure where I have to manually generate it.

Does anyone have any ideas or recommendations on how to achieve this.

Any help would be much appreciated.

Thanks

[dilipandey]

Hi mtsykes28,

If your columns are fixed, you can draw and keep the pivot structure separately and then at the end of the month you can just refresh that pivot.
Also if you have the pivot data source keeps changing/ adding, you can use a dynamic name to take care of that.

Hope this helps

Regards,
DILIPandey

<click on below 'star' if this helps>

[mtsykes28]

I need the pivot table to be automatically generated at the end of the month. No manual interaction if I can help it. Is that possible?

Thanks

[MarvinP]

Hi,
See if this page answers your question.
http://www.get-digital-help.com/2011...in-excel-2007/

[mtsykes28]

Thanks very much - this is what I was after.