+ Reply to Thread
Results 1 to 13 of 13

copy and paste macro

  1. #1
    Forum Contributor
    Join Date
    09-07-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    100

    copy and paste macro

    Hi,

    -I need a simple copy and paste macro which copy all contents from column A:M that has something in the cell

    -it needs to copy from sheet2 to sheet 4

    -the paste into sheet 4 has to exclude row1, therefore pasting into row2 and onwards.

    -i want to keep copying and pasting every day to keep long term data, therefore i need to insert the following days data above yesterdays data.

    regards,

    burdo

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: copy and paste macro

    Use your macro recorder to come up with something.

    http://www.xlorate.com/create-excel-macros.html

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: copy and paste macro

    Maybe:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    09-07-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: copy and paste macro

    it doesn't bump the old data down.

    when i click the macro more than once it will copy and paste in the same spot, rather than bumping old data down the page then pasting the new data at the top.

    regards,

    burdo

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: copy and paste macro

    Umm. Worked for me when I tested it. Can you provide a sample file in which it does not work? Or maybe I'm misunderstanding something.

  6. #6
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: copy and paste macro

    Try

    Please Login or Register  to view this content.
    Last edited by JasperD; 04-01-2015 at 08:19 AM.
    Please click the * below if this helps

  7. #7
    Forum Contributor
    Join Date
    09-07-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: copy and paste macro

    jasper has the right idea.. However it inserts a heap of blank cells in between the two copy and pastes

  8. #8
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: copy and paste macro

    I assumed all your columns would have the same amount of data.
    Just adjust it to delete empty cells or copy & paste per column.

  9. #9
    Forum Contributor
    Join Date
    09-07-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: copy and paste macro

    no they don't always have the same amount of data, its hassle to delete the empty rows

  10. #10
    Forum Contributor
    Join Date
    09-07-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: copy and paste macro

    ill insert my sheet and you can take a look.......
    Attached Files Attached Files

  11. #11
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: copy and paste macro

    it's cause your cells contain formulas....
    Use this:
    Please Login or Register  to view this content.
    Last edited by JasperD; 04-01-2015 at 09:22 AM.

  12. #12
    Forum Contributor
    Join Date
    09-07-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: copy and paste macro

    thanks it works fine,

    cheers

  13. #13
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: copy and paste macro

    Great. Please mark this thread as solved (thread tools -> mark thread as solved).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy paste - cute paste macro almost working
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2014, 12:33 PM
  2. Copy & paste in macro doesn't paste all cells
    By pltrapper in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-13-2013, 09:22 AM
  3. [SOLVED] Simple copy and paste macro- Paste special help needed.
    By hernancrespo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2012, 07:02 AM
  4. 2 Macro's: only vertical copy/paste action and copy-paste 14 columns to the right.
    By vdongen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2010, 10:34 AM
  5. Copy and Paste macro needs to paste to a changing cell reference
    By loulou in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2005, 07:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1