Hi guys,
I have a database where each month the same 30 pivot tables are created from the database. Is there a way where you can have a form or report that generates the same pivot tables (and possibly charts) in one area. That way I can bring this across to Excel in one process.
The process at the moment is to have 30 separate forms which are pivot tables. For each one I export to excel and then copy and paste in to another excel file where I keep all the data together.
Any help would be greatly appreciated!
Thank you!