+ Reply to Thread
Results 1 to 2 of 2

macro to copy and paste rows at the end of data

  1. #1
    Registered User
    Join Date
    07-19-2007
    Posts
    51

    macro to copy and paste rows at the end of data

    I want to create a button that when clicked will copy specific rows and paste them at the end populated records.
    Specifically, I have a document to record expenses... there are a set of questions (rows 8 -20) that will initially be repeated 3 to 5 times. IF the user needs more than these, then he/she can click the button and one more additional set will be pasted after the last set of questions (but before the button). In the attached spreadsheet, it would mean that the additional rows are pasted between lines 48-49. Upon a second button click, the lines would be pasted at approximately 61-62, and a third click at approx 74-75, etc etc

    I tried recording a macro but that pastes the rows in the same position rather than at the end of the data.

    any help would be appreciated.

    file attached

    thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: macro to copy and paste rows at the end of data

    This would do you, add it to a standard module then assign the macro to the button
    Please Login or Register  to view this content.

    Google Me
    Find me located here Simon Lloyd
    and what i'm about Here
    The above is NOT a link to a forum so is NOT against Rule 13
    Last edited by Simon Lloyd; 02-15-2012 at 10:45 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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