Trying to copy data to another sheet upon H1 = Suspended, any ideas what I am doing wrong here?
Thanks.
Private Sub Worksheet_Calculate()
NextDataRow = Sheets("Data").Range("B" & Rows.Count).End(xlUp).Row + 1
If Range("H1") = "Suspended" Then
Range("AG1:BC1000").Copy...