+ Reply to Thread
Results 1 to 5 of 5

Macro to move certain rows up one

  1. #1
    Registered User
    Join Date
    08-27-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    7

    Macro to move certain rows up one

    Hello, looking for a code to move rows that contain a certain word up one at the end of the row above. Due to privacy I can't attache a copy of the spreadsheet but hopefully that makes sense.
    If Column F in a row contains the word 'Parent' cut the row from column A to column O and paste into column P in the row directly above it.
    Thank you,

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,414

    Re: Macro to move certain rows up one

    Hi leah72,
    Code to try :
    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to move certain rows up one

    Another:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-27-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Macro to move certain rows up one

    Thank you, sorry I was away from computer for awhile. I will give these a try this afternoon. Thank you for your help.

  5. #5
    Registered User
    Join Date
    08-27-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Macro to move certain rows up one

    GC Excel thank you! It worked like a charm and I never would have figured that out myself. Much appreciated.

+ 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] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 05:08 PM
  2. [SOLVED] Macro to move rows from one tab to another
    By Mark D Flanagan in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-11-2012, 11:09 AM
  3. [SOLVED] Macro to copy rows and move to another row
    By slohman in forum Excel General
    Replies: 2
    Last Post: 05-18-2012, 07:46 PM
  4. Macro to move rows to different sheet
    By pmhabo in forum Excel General
    Replies: 2
    Last Post: 08-18-2010, 01:39 PM
  5. Macro/VBA to move rows to another sheet
    By Pat Parker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-12-2010, 12:37 PM

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