Results 1 to 6 of 6

Duplicate a row several times, append info, then repeat

Threaded View

  1. #1
    Registered User
    Join Date
    07-22-2010
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007
    Posts
    1

    Duplicate a row several times, append info, then repeat

    I don't know how complicated or simple this is, but I urgently need a macro that does the following for 372 rows.

    Copy one row, duplicate it (either into a new sheet or on the current sheet) so that there are now 4 instances of the row, then append different bits of text to the cell in the first column of each of these four rows (append "-43", "-6", "-8", and "-10" respectively).

    I know I probably did a horrible job of describing that, so I have attached an XLSX book. The "Beginning" sheet is a very condensed example of what I have now. The "End" sheet is what it would look like after the macro has been executed.

    Obviously, doing this manually to 372 rows would be very time consuming and I really need to have this done soon.

    Thank you very very much to whoever can help!

    Edit: I have also uploaded the example workbook as a XLS file.
    Attached Files Attached Files
    Last edited by artizhay; 07-22-2010 at 02:19 AM.

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