Macro Help- Copy, Analyze, Create Graph

DragonMan - Jun 2, 2009 at 10:44 AM
 autogeeek - Jun 8, 2009 at 02:16 AM

I'm trying to write a macro that will take an xls file that has only one sheet, create a second worksheet within the excel file, copy and paste (but not delete) a selected range of data from the first worksheet into A1 of the second (by calling the range for the range to be copied via the text that is in the cell, not by the cell location), analyze the data in the second worksheet, and create a line graph as a new sheet.

So essentially picture the original xls file having a ton of data on sheet one but because the data varies month to month but the headers of the range that I need copied doesn't, I want to call it based off the data header so it can be consistently used.

I'm so lost-


1 reply

Hi DragonMan,

Why don't you try a simple macro recorder wherein you will have to simply record a task to insert the commands that you require for your excel application.
try a free download of workspace macro recorder @
Hope this helps.