Macro Help- Copy, Analyze, Create Graph [Closed]

Question

Macro Help- Copy, Analyze, Create Graph [Closed]

Report

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

Hello,

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-

Thanks

Macro Help- Copy, Analyze, Create Graph
Excel macro to create new workbook based on value in cells ✓ - Forum - Excel
Excel macro to create new sheet based on value in cells - How-To - Excel
Macro to create new sheet and copy data - Forum - Excel
Outlook - A macro to create folders - How-To - Office Software
Use a Macro to Create New Workbook and Copy Data in Excel - How-To - Excel

1 reply

Ask a question

autogeeek · Answer 1 · 2009-06-08T02:16:38-0400

Answer 1 / 1

autogeeek
Jun 8, 2009 at 02:16 AM

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 @ http://www.tethyssolutions.com/product.htm
Hope this helps.

Macro Help- Copy, Analyze, Create Graph [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!