+ Reply to Thread
Results 1 to 2 of 2

Select cells, copy, paste, move down one row repeat

  1. #1
    Registered User
    Join Date
    09-18-2009
    Location
    Anchorage, Alaska
    MS-Off Ver
    Excel 2003
    Posts
    1

    Select cells, copy, paste, move down one row repeat

    Is there was a way to create a macro that copies selected cells in a row, paste the copied cells into a set number of rows below that row of selected cells, move to the next row following the pasted cells and repeat the process of selecting the cells from that new row? I need to do this both for selected rows and transposing selected cells in a row. I have provided the macro created by doing this manually over and over. Hopefully there is an easier way.

    '****copy and paste into specific number of rows
    Please Login or Register  to view this content.

    '*****this one is transposing
    Please Login or Register  to view this content.
    Thanks
    David
    Last edited by tellerak; 09-18-2009 at 05:56 PM. Reason: Needed to add code tags

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Select cells, copy, paste, move down one row repeat

    Welcome to the forum.

    Please take a few minutes to read the forum rules, and then edit your post to add code tags.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

+ 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