Is it possible to create a macro or VB Script that will do the following.
Once data is imported into the spreadsheet and parsed correctly, a chart needs to be generated and labelled correctly. This is a routine task that happens every Wednesday as new data from log files is automatically pulled in.
For example I have data from testing for week one and it is manually entered into a chart, I do the same for weeks 2 and 3 respectively. However, since the testing is the same and the only thing that really changes is the number of hours a test is run.
I would like to setup up a method for the data to be pulled into a chart automatically and added to the previous weeks testing data in the chart
I have included the file here for example
thanks
Shaun
Bookmarks