automatically moving a row of data on cell entry RRS feed

  • Question

  • I have a worksheet with several rows of data.  One of the columns has a data list of "status"es from a drop down list box.  I have conditional formatting on the rows so that when the status is "Completed", the entire row goes to a soft grey font.  I now need to have that row automatically move to the first empty row at the bottom of the worksheet.  I know it's easy to just cut and paste it, but I'd really rather not have to do it that way.  I'd just like to be able to select "Completed" and have the row move.  Is there a VB code that would do this?
    Thursday, May 15, 2014 12:38 PM


  • freddb34 Vertex --

    Is this a question about Microsoft Project, a project management application?  It sounds like your question is about Microsoft Excel.  If your question is about Microsoft Project, please elaborate.  If not, please consider reposting your question in one of the Excel user forums.  Hope this helps.

    Dale A. Howard [MVP]

    Thursday, May 15, 2014 12:42 PM