Nevermind I solved it with this from info I have picked up from here. This is what I did:
If ws1.Cells("73", "I") = "Y" And ws1.Cells("78", "A") > 0 And ws3.Cells("7", "K") = "No Win(s)" Then
ws3.Cells("8", "K").Value = 0
ws3.Cells("7", "K").Value = "Win(s)"
End If
If ws1.Cells("73", "I") = "Y" And ws1.Cells("78", "A") = 0 And ws3.Cells("7", "K") = "Win(s)" Then
ws3.Cells("8", "K").Value = 0
ws3.Cells("7", "K").Value = "No Win(s)"
End If
ws3.Cells("8", "K").Value = ws3.Cells("8", "K").Value + 1
I have learned quite a bit from just reading through the forums. I really appreciate all that contribute.
You guys rock!
Bookmarks