software

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:

www.mvps.org/dmcritchie/excel/getstarted.htmYou might also look at David's tutorials page at:

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

The VBA material is towards the end of that section.---
Regards,
Norman
quot;Aries6quot; gt; wrote in message
...
gt;I need to write an Excel macro. Is there a tutor somewhere, or simple
gt; directions? I need to move specific data from one spreadsheet to another.
gt; I
gt; would need to identify the range in the first spreadsheet, to paste into
gt; the
gt; second sheet.
gt;
gt; I would create this report monthly, and sometimes the data is not in the
gt; same range.
gt;
gt; 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.

www.rondebruin.nl/copy1.htmGord Dibben Excel MVP

On Fri, 16 Dec 2005 09:10:13 -0000, quot;Norman Jonesquot;
gt; wrote:

gt;Hi Airies6,
gt;
gt;You may wish to visit David McRitchie's 'Getting Started With Macros And
gt;User Defined Functions' at:
gt;
gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt;
gt;
gt;You might also look at David's tutorials page at:
gt;
gt; www.mvps.org/dmcritchie/excel....htm#tutorials
gt;
gt;The VBA material is towards the end of that section.
gt;
gt;
gt;---
gt;Regards,
gt;Norman
gt;
gt;
gt;
gt;quot;Aries6quot; gt; wrote in message
...
gt;gt;I need to write an Excel macro. Is there a tutor somewhere, or simple
gt;gt; directions? I need to move specific data from one spreadsheet to another.
gt;gt; I
gt;gt; would need to identify the range in the first spreadsheet, to paste into
gt;gt; the
gt;gt; second sheet.
gt;gt;
gt;gt; I would create this report monthly, and sometimes the data is not in the
gt;gt; same range.
gt;gt;
gt;gt; Any suggestions?
gt;