How do I set up an automatic delete or move of a row of data?

Z

Zo

I have a job summary that lists the status of my projects. I want to move
the data and close up the gaps in the spreadsheet as I change the status to
"complete".
 
R

Rowan Drummond

You need to provide more information. For example, how do you change the
status to complete and where do you want to move the data to?

Regards
Rowan
 
Z

Zo

I have a list that identifies the "status" of the project (i.e. "incomplete,
"in progress," etc.). When the status is changed to "complete", I want that
row to go away.
 
R

Rowan Drummond

You could use a change event similar to this. SAVE your data before
testing this. Rows will be deleted with no way to retrieve them!

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count = 1 Then
If Target.Value = "Complete" And _
Target.Column = 1 Then 'change column as required
Target.EntireRow.Delete
End If
End If
End Sub

This is worksheet event code. Right click the sheet tab, select view
code and paste the event in there. This assumes you list is in column A.
If not change Target.Column = 1 to the correct column.

Regards
Rowan
 
Top