Hi All, I thought I was getting on well with the Macro Recorder being my friend but I am stuck with Pivot Table/Chart creation and need some help.

My little project is a one page report with a mixture of Charts, Tables and some freehand. I have successfully opened the CSV file on which the report will be based, corrected some data formatting, split some fields and written the data to a worksheet so all very good up to that point.

What I was hoping to achieve was a position that after that import the Charts and Tables on the Report worksheet could be updated automatically, in other words after the import I have a newly updated report and that's where the wheels fell off.

The data which is import will vary in length, the column count will be the same but the row count will differ depending on the date range and amount of data so how do I code that as the macro recorded code below is for fixed length data and fails when I try to run it as standalone.

I created this example to produce a pivot table summary by Quarter on another sheet thinking the relevant chart on the Report sheet would then update automatically with the data reference being fixed. Maybe in my newby ignorance that is a flawed direction of thought so please feel free to offer any advice or further reading that may help.

My main code so far is at the bottom of this post and is functional, it doesn't have to be quick. I just want to have a visually designed report with some charts and tables updated from summary data of this imported CSV file each time it is run.

Very new to this so all suggestions and pointers welcome, Thanks in advance

Please Login or Register  to view this content.
Please Login or Register  to view this content.