Copy_to_sheet macro

  • Thread starter Thread starter mlmjr
  • Start date Start date
M

mlmjr

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to copy A1 tp J(bottom) 1
Altered pasting functionality 3
macro changes sheet location 2
Should I be content with the time code takes? 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Macro to restore previous content of clipboard 3
Run macro from active workbook whose name keeps changing 20
Programatically changing the macro content. 1

Back
Top