JimS
07-29-2009, 09:27 AM
I have a Workbook Template that is created by importing (copying other worksheets). The number of worksheets that get imported into Workbook Template can vary from 1 -32 sheets. Each sheet that gets imported comes in with the sheet name of Sheet1, Sheet1(2), Sheet1(3), Sheet1(4), Sheet1(5), etc. The data on each of these imported sheets can vary in size (vary in rows and columns).
I need to automatically create a Column Chart for each of the sheets that get imported.
Not sure if this is possible but knowing the talent and expertise of this forum I thought I would see if anyone has any ideas on how to accomplish this.
To make it harder (as if this isn’t hard enough), the number of Columns and Rows on any of the imported sheet can vary.
I do not want to chart all the columns, but only certain ones (and only if they exist on the individual sheet).
The data points will always start in Row 5. Using Columns A, C & D, I & J, O & P, U & V, etc, etc, etc (if these columns exist on the sheet).
There is always Column A and C & D, after that (if they exist) the next columns are 6 columns out, and then 6 more, and so on. Always 6 columns out from column C and 6 columns out from column D.
I manipulate the data on the imported sheets with various vba routines before the Column Charts can be created, but the last thing I do is rename each of the imported sheets (using a portion of what is in a cell on the sheet.
I write the new sheet names out to another sheet called Names – perhaps have a list of the sheets that need a Chart will help.
Does anyone have any ideas on how to go about this?
Thanks for any and all help…
I have attached a smaller example of how the imported sheets look.
Jim
I need to automatically create a Column Chart for each of the sheets that get imported.
Not sure if this is possible but knowing the talent and expertise of this forum I thought I would see if anyone has any ideas on how to accomplish this.
To make it harder (as if this isn’t hard enough), the number of Columns and Rows on any of the imported sheet can vary.
I do not want to chart all the columns, but only certain ones (and only if they exist on the individual sheet).
The data points will always start in Row 5. Using Columns A, C & D, I & J, O & P, U & V, etc, etc, etc (if these columns exist on the sheet).
There is always Column A and C & D, after that (if they exist) the next columns are 6 columns out, and then 6 more, and so on. Always 6 columns out from column C and 6 columns out from column D.
I manipulate the data on the imported sheets with various vba routines before the Column Charts can be created, but the last thing I do is rename each of the imported sheets (using a portion of what is in a cell on the sheet.
I write the new sheet names out to another sheet called Names – perhaps have a list of the sheets that need a Chart will help.
Does anyone have any ideas on how to go about this?
Thanks for any and all help…
I have attached a smaller example of how the imported sheets look.
Jim