Results 1 to 7 of 7

Macro to Insert Row, Copy & Paste all-in-1

Threaded View

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    KL
    MS-Off Ver
    Excel 2010
    Posts
    37

    Macro to Insert Row, Copy & Paste all-in-1

    Hi,

    I have to do a lot of entries which looks like this :-

    Row 1 : AAAAAAA (Data in several columns)
    Row 2 : BBBBBBB
    Row 3 : CCCCCCC

    I need to insert 1 row (sometimes 2 rows) directly below a selected tow (eg. Row 1), and then copy everything in row 1 & pasted to the newly created row(s).
    So the output will be something like this :-

    Row 1 : AAAAAAA
    Row 2 : AAAAAAA
    Row 3 : AAAAAAA
    Row 4 : BBBBBBB
    Row 5 : BBBBBBB
    Row 6 : CCCCCCC

    Currently, I manually insert row, copy & paste, repeat repeat & I have a lot of rows to handle.
    Would appreciate if anyone could help me ease my task.
    Thanks!
    Last edited by donkeybusiness; 08-30-2012 at 10:08 PM.

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