Closed Thread
Results 1 to 2 of 2

Macro function to copy and paste lines at end of data

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

    Macro function to copy and paste lines at end of data

    Hi, I want to create a form with recurring fields for data entry. If the user needs more formatted lines he/she can click a button which will copy and paste rows at the end of the exisiting data.

    Specifics for attached spreadsheet:
    Expense form: rows 8 thru 20 reflect repeatable data that will be copied upon button click
    Upon button click, row 8-20 will be pasted between row 48 & 49
    Upon additional button click rows 8-20 will be pasted between 61 & 62,
    etc etc

    I tried recording a macro but that always winds up pasting the rows in the same place rather than at the end of the current data

    thanks
    Attached Files Attached Files

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Macro function to copy and paste lines at end of data

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

Closed 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