The folowing code needs to be implemented into the "Open Issues" sheet.
Right click on the sheets name and select "view code", paste the code in the big white field.
The code looks at column D. Whenever a value in this column is changed to "Closed", then the entire row is copied to the first available row on the "Closed Issues" sheet as values. On the "Open Issues" sheet the copied row will be cleared except for the formula's.
Here is the code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim lCol As Integer
If Intersect(Target, Columns("D:D")) Is Nothing Then Exit Sub
If Target.Value = "Closed" Then
lCol = Cells(Target.Row, Columns.Count).End(xlToLeft).Column
Range(Cells(Target.Row, 1), Cells(Target.Row, lCol)).Copy
Sheets("Closed Issues").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValues
For Each cell In Range(Cells(Target.Row, 1), Cells(Target.Row, lCol))
If cell.HasFormula = False Then cell.ClearContents
Application.CutCopyMode = False
Hope you like.