Moving updated data to specific sheet

[scrumpyjack]

I have a spread sheet called Cases 2014
I have another spread sheet in the same work book called ONGOING cases and another sheet called COMPLETED cases.
I have two macros that update these two spread sheets ie when 'ongoing' is typed in the status column (column 24) of 'Cases 2014' the info required is copied to the ONGOING sheet.
When Completed is typed into the status column of Cases 2014 the COMPLETED sheet is updated with required data.
They both work perfectly but....
The ONGOING sheet as it implies needs updating regularly for reporting purposes.
The trouble is if I over type 'ongoing' in the 'status' column of the Cases 2014 I get that line of data reproduced again on another line ie I would like the original line of data either erased so the new data takes preference or just the items in that line updated.
Here is a copy of that code.
Sorry not sure how to do the whizzy hide thing! Fred

If Target.Count = 1 Then
          If Target.Column = 24 Then
              If LCase(Target.Value) = "ongoing" Then
                 Intersect(Range("A:A,G:G,H:H,J:K,V:V"), Target.EntireRow).Copy _
                          Destination:=Worksheets("Ongoing cases").Cells(Rows.Count, 1).End(xlUp).Offset(1)
              End If
          End If
      End If
End Sub