I need to write an Excel macro. Is there a tutor somewhere, or simple
directions? I need to move specific data from one spreadsheet to another. I
would need to identify the range in the first spreadsheet, to paste into the
second sheet.

I would create this report monthly, and sometimes the data is not in the
same range.

Any suggestions?

Hi Airies6,

You may wish to visit David McRitchie's 'Getting Started With Macros And
User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


You might also look at David's tutorials page at:

http://www.mvps.org/dmcritchie/excel....htm#tutorials

The VBA material is towards the end of that section.


---
Regards,
Norman



"Aries6" wrote in message
...
I need to write an Excel macro. Is there a tutor somewhere, or simple
directions? I need to move specific data from one spreadsheet to another.
I
would need to identify the range in the first spreadsheet, to paste into
the
second sheet.

I would create this report monthly, and sometimes the data is not in the
same range.

Any suggestions?

After a trip to David's site..........

For some sample code for copying data see Ron de Bruin's site.

Many good routines here.

http://www.rondebruin.nl/copy1.htm


Gord Dibben Excel MVP

On Fri, 16 Dec 2005 09:10:13 -0000, "Norman Jones"
wrote:

Hi Airies6,

You may wish to visit David McRitchie's 'Getting Started With Macros And
User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


You might also look at David's tutorials page at:

http://www.mvps.org/dmcritchie/excel....htm#tutorials

The VBA material is towards the end of that section.


---
Regards,
Norman



"Aries6" wrote in message
...
I need to write an Excel macro. Is there a tutor somewhere, or simple
directions? I need to move specific data from one spreadsheet to another.
I
would need to identify the range in the first spreadsheet, to paste into
the
second sheet.

I would create this report monthly, and sometimes the data is not in the
same range.

Any suggestions?