I have a report that I run once a month and then create a pivot table and from that create a pivot graph.
Is there any easy way to automate this? I have tried Macros but I can't get it to work as the number of lines will change month in, month out.
I would just like to export the report form...