title: In Excel, how can I conditionally cut a row of data and move it to another worksheet permanantly?
body: <p>I have a worksheet with all my projects listed.  When I have marked one row (project) as "Finaled" from a drop down in column D, I want the entire row to be moved to my "Finaled" worksheet and permanantly stay on that worksheet. </p>
  
  <p>I have basic programming knowledge, and have come up with this Macro...</p>
  
  <pre><code>    Sub Finaled()
      Dim i, LastRow
  
      Sheets("FINALED").Range("A2:Z500").ClearContents
      For i = 19 To LastRow
      If Sheets("ACTIVE").Cells(i, "D").Value = "Finaled" Then
      Sheets("ACTIVE").Cells(i, "D").EntireRow.Copy Destination:=Sheets("FINALED").Range("A" &amp; Rows.Count).End(xlUp).Offset(1)
      End If
      Next i
      End Sub
  </code></pre>
  
  <p>...but this isn't working exactly like I want it to. The first problem is it only copies the row of information, and when I manually delete the row from my main worksheet, the next time I run the Macro, I lose the originally copied rows of data on my Finaled worksheet.  I want it to completely cut the row of data and move it to my "Finaled" worksheet, and keep it there permanently.</p>
  
  <p>Second, can this move happen automatically as soon as I mark the row as "finaled" from my drop down list in column D?  Or do I have to manually run the Macro everytime?  </p>