archleo
12-12-2006, 08:47 AM
Hi to every one...
I have a workbook containing several worksheets. Every sheet has its own dynamic data which I update daily. Using this dynamic data, I create charts of 1 to 3 in each page. Monthly, these charts has to be renewed without deleting the old ones. Old charts has to be moved to a seperate sheet by renaming those "chart sheets" something like Sheet1_LastMonth, Sheet2_LastMonth.....and so on.
I have wrote down a piece of code for this, but I couldn't be able to change the location of the charts. In fact my code only "detects" the charts which are embedded in Sheet1. The rest is not detected.
Can you help me solving this mess??
Thanx
Levent
I have a workbook containing several worksheets. Every sheet has its own dynamic data which I update daily. Using this dynamic data, I create charts of 1 to 3 in each page. Monthly, these charts has to be renewed without deleting the old ones. Old charts has to be moved to a seperate sheet by renaming those "chart sheets" something like Sheet1_LastMonth, Sheet2_LastMonth.....and so on.
I have wrote down a piece of code for this, but I couldn't be able to change the location of the charts. In fact my code only "detects" the charts which are embedded in Sheet1. The rest is not detected.
Can you help me solving this mess??
Thanx
Levent