How To Create A Macro To Copy And Paste Specific Cells To Another Worksheet (excel)?

Im trying to copy the date of sale (G7) and the total (B34) on the Order Form sheet and then paste them onto the sales sheet. I also need each order generated in the order form to be pasted onto its own line in the sales sheet. For example: Order 1 – Date 12/3/12 – Total Sale £1222
Order 2 – Date 13/4/12 – Total Sale £3443
I hope I make sense, if someone could help that would be great. Thanks. ))

Both comments and pings are currently closed.

One Response to “How To Create A Macro To Copy And Paste Specific Cells To Another Worksheet (excel)?”

  1. steve_lo says:

    The easiest way is to use Tools, Macro, Record New Macro.
    Do the moves, ie Copy and Paste.
    Then stop Record and look at the code it generates.
    You can modify it if needed.

Powered by WordPress | Designed by: free css template | Thanks to hostgator coupon and web hosting reviews