+ Reply to Thread
Results 1 to 4 of 4

Automatically move a row of data based on cell value

  1. #1
    Registered User
    Join Date
    05-22-2012
    Location
    IL
    MS-Off Ver
    Excel 2010
    Posts
    50

    Automatically move a row of data based on cell value

    I have found a number of threads regarding this topic, but have not seemed to find a solution that works. I have a table of data ("Current" sheet) with column C representing the project status. When a cell in column c is set to "C" (through data validation), I would like the corresponding row of data to move to the next available row on the "Completed" sheet. Can someone please provide a solution...I can't seem to get it right.

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Automatically move a row of data based on cell value

    Hi,

    Please Login or Register  to view this content.
    Regards

  3. #3
    Registered User
    Join Date
    05-22-2012
    Location
    IL
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Automatically move a row of data based on cell value

    Hi tehneXUs, this works nicely! However, I was hoping to have this code run automatically when the cell is changed to "C". Using this as a macro will only copy one row of data at a time, and if the user changes multiple cells to completed and runs the macro, it will only transfer one line of data. Can this be done automatically based on cell value?

  4. #4
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Automatically move a row of data based on cell value

    Hi,

    I assume you have no heading in "Completed"-sheet, nevermind. use this in a standard module (attention: code changed):
    Please Login or Register  to view this content.
    and this in the worksheet module of "Current"-worksheet
    Please Login or Register  to view this content.
    Each time column C in "Current"-worksheet is changed to "C", either 1 cell or more, all rows where column C is "C" will be moved to the end of the "Complete"-worksheet.
    As you mentioned you are using data validation it might not work depending on the way.

    Regards

+ 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