+ Reply to Thread
Results 1 to 2 of 2

Easy Macro to Copy/Paste a series of rows

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    09-08-2016
    Location
    Buffalo, NY
    MS-Off Ver
    365
    Posts
    115

    Easy Macro to Copy/Paste a series of rows

    I've tried a couple different attempts at macros but haven't quite found what I'm looking for. I want to create a macro to assign to a button that will automatically copy/paste a series of rows. In the attachment I am looking to copy Rows 8-18 each time I click a button. These rows can be pasted in Row 20. I know there is probably a simple macro to suit my need but I'm very new to these so any help is appreciated.

    Once I've got the macro created I can complete the button part on my own.

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,957

    Re: Easy Macro to Copy/Paste a series of rows

    Try this...Basic recordered code. Can change to be more detailed if you like.
    Sub Macro1()
        Rows("13:18").Select
        Selection.Copy
        Rows("20").ActiveSheet.Paste
    End Sub
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

+ 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. [SOLVED] Macro Help Copy&Paste Rows
    By Leoparddd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2014, 02:35 PM
  2. Macro to copy rows based on moving date and paste the rows into an identical sheet
    By ivandc1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2014, 11:59 AM
  3. [SOLVED] Macro to copy 4 rows and paste every 6th row
    By gavinharper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2013, 10:49 AM
  4. [SOLVED] Easy Copy-Paste Question
    By ExcelFinWizzard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2012, 08:36 AM
  5. Macro to Copy/Paste 4 Rows over 500 Rows
    By snapa in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-20-2009, 12:21 PM
  6. A macro to copy and paste four rows
    By d_rock90 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-06-2008, 10:15 PM
  7. Copy / Paste Easy
    By willwonka in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-27-2006, 10:25 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