Sorry, I meant that if a line was already copied to the master once is there any way to identify it when data it again. What I wanted to do was delete the previously copied line in Master (not the line in original worksheet that the data was from) and insert the newly changed data where the old data was.
I tried doing this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If ActiveSheet.UsedRange.Columns.Count Then
If Len(Trim(Target.Value)) <> 0 Then
Target.EntireRow.Copy Worksheets("Master").Cells( _
But that only deletes the line in the original worksheet. I don't even know if it's possible to do what I want here, but thanks for your help so far.