+ Reply to Thread
Results 1 to 4 of 4

VBA to find, copy and insert mulitple copied rows (newbie)

  1. #1
    Registered User
    Join Date
    05-17-2010
    Location
    Tennessee
    MS-Off Ver
    Office365
    Posts
    24

    VBA to find, copy and insert mulitple copied rows (newbie)

    Hello all,

    I am trying to create a macro to find a group of rows, copy and them and insert them above the existing rows.

    In column A, I need to find the cell containing the text "Insert new projects". Then I want it to copy all of the rows below that until it gets to a cell that says "Summary". Then I want it to insert/paste all of those rows (the ones between "Insert..." and "Summary") above the "Insert..." row exactly as they are.

    This could include 10 rows or 30, just depending on the sheet it's run on, but it will always be the rows between (but not including) "Insert New Projects" and "Summary".

    Any help would be very much appreciated.

    Thanks,
    RL

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,450

    Re: VBA to find, copy and insert mulitple copied rows (newbie)

    Am I being Thick here?

    All you will achieve is to move the row "Insert New Projects" be;ow the row "Summary"

    Is that what you want to achieve?

  3. #3
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: VBA to find, copy and insert mulitple copied rows (newbie)

    I read it a little differently. Maybe you are looking for this?

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    05-17-2010
    Location
    Tennessee
    MS-Off Ver
    Office365
    Posts
    24

    Re: VBA to find, copy and insert mulitple copied rows (newbie)

    stnkynts,

    That is exactly it!!! It works like a charm. You're my new hero!

    I'm trying to learn more VBA but mine is really clunky and rarely error free. I love forums like this where I can get code to study to learn to do it myself next time.

    Really appreciate your help!

    Randi Lee

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] insert rows COPIED
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2012, 09:38 AM
  2. trouble with vba code for Find, Insert copied cells and find next
    By jgelbach in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-26-2012, 01:45 PM
  3. How to insert 5 copied rows every other row?
    By madame2fly in forum Excel General
    Replies: 1
    Last Post: 10-22-2008, 11:18 PM
  4. Find, Copy and Insert Copied Column
    By kojack75 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2007, 09:49 AM
  5. Can't Insert Copied Rows
    By Kent in forum Excel General
    Replies: 0
    Last Post: 04-07-2005, 06:54 PM

Tags for this Thread

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