Advertisement
Guest User

Untitled

a guest
Jul 28th, 2016
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2. Sheets("log").Cells(1, 1).Value = "Date"
  3. Sheets("log").Cells(1, 2).Value = " Equipment"
  4. Sheets("log").Cells(1, 3).Value = "Old Status"
  5. Sheets("log").Cells(1, 4).Value = "New Status"
  6. Sheets("log").Cells(1, 5).Value = "Old Reason"
  7. Sheets("log").Cells(1, 6).Value = "New Reason"
  8. Sheets("log").Cells(1, 7).Value = "Old Action"
  9. Sheets("log").Cells(1, 8).Value = "New Action"
  10. If Target.Value <> PreviousValue Then
  11. Sheets("log").Cells(65000, 1).End(xlUp).Offset(1, 0).Value = Now
  12. Sheets("log").Cells(65000, 2).End(xlUp).Offset(1, 0).Value = Range()
  13. End If
  14. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement