+ Reply to Thread
Results 1 to 7 of 7

Move Row to Another Worksheet Once Status is changed

  1. 05-03-2012, 02:05 PM #1
    cbelle508
    cbelle508 is offline
    Registered User
    Join Date
    05-03-2012
    Location
    DC
    MS-Off Ver
    Excel 2010
    Posts
    3

    Unhappy Move Row to Another Worksheet Once Status is changed

    Hi Everyone, I am new here. I have scoured the internet looking for a code that will work for my situation. I have copied macros code and tried to adapt it to what I need, but nothing seems to work for me.
    I have a work sheet, and for each entry that is marked "Closed: By SEG POC" or "Closed: Referred" , I would like the entire row to move to the Closed Log worksheet.
    Once that row is removed, I want that now vacant row to delete and move up so there are no blank spaces in either worksheet. Thanks to anyone who can help me out!!!
    TEST_Inquiry_Log.xls
    Reply With QuoteRegister To Reply
  2. 05-03-2012, 02:24 PM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Move Row to Another Worksheet Once Status is changed

    Which of these do you want to happen -

    1. As soon as the entry is marked, the movement happens.

    2. All entries are marked, then on the click of a button, the movement happens.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  3. 05-03-2012, 02:29 PM #3
    cbelle508
    cbelle508 is offline
    Registered User
    Join Date
    05-03-2012
    Location
    DC
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Move Row to Another Worksheet Once Status is changed

    Hi Arlette,
    I would need it to move at the click of a button (option #2).
    Reply With QuoteRegister To Reply
  4. 05-03-2012, 02:54 PM #4
    GeneralDisarray
    GeneralDisarray is offline
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Move Row to Another Worksheet Once Status is changed

    see attached (macro is also below)
    Please Login or Register  to view this content.
    --edit--

    Forgot to mention, the button to run the macro (and move the rows) is sitting in the top left cell, A1.
    Attached Files Attached Files
    Last edited by GeneralDisarray; 05-03-2012 at 02:59 PM. Reason: forgot to mention button
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.
    Reply With QuoteRegister To Reply
  5. 05-03-2012, 03:05 PM #5
    cbelle508
    cbelle508 is offline
    Registered User
    Join Date
    05-03-2012
    Location
    DC
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Move Row to Another Worksheet Once Status is changed

    Thank you soooo much!! Is there a way to make this macro run automatically upon opening?
    Reply With QuoteRegister To Reply
  6. 05-03-2012, 03:08 PM #6
    GeneralDisarray
    GeneralDisarray is offline
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Move Row to Another Worksheet Once Status is changed

    yes, you can do that, i'll post up the change
    Reply With QuoteRegister To Reply
  7. 05-03-2012, 03:13 PM #7
    GeneralDisarray
    GeneralDisarray is offline
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Move Row to Another Worksheet Once Status is changed

    added a workbook open event (easy to do if you google workbook events / worksheet events for excel)


    I also made the workbook open to that sheet regardless of which sheet was last open at the previous save/close. Just thought you might need that too.



    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1