Hello, anyone help start me on a macro to copy a range of
data adn paste to a new worksheet ,create name, create
page break around perimeter (a page size)for printing
individually at print time.

say, data to be copied is in cells A3:D53 and to paste to
new wroksheet and call it a month1 and then when it needs
to be copied again...to paste it beside or beneath (a
statement for under and then one for next to, so we can
pick) the previous copied data and carry on. any ideas
how i can create a macro?
thank you in advance~!

Tools|macros|Record New Macro is a very nice way to get started.

When/if you get stuck, post back.

mlmjr wrote:

Hello, anyone help start me on a macro to copy a range of
data adn paste to a new worksheet ,create name, create
page break around perimeter (a page size)for printing
individually at print time.

say, data to be copied is in cells A3:D53 and to paste to
new wroksheet and call it a month1 and then when it needs
to be copied again...to paste it beside or beneath (a
statement for under and then one for next to, so we can
pick) the previous copied data and carry on. any ideas
how i can create a macro?
thank you in advance~!

--

Dave Peterson