winning streak....

Looking to insert vba code to update winning / no wins streak

sheet1 A78 if it >1 then that means win if=0 that means no win

sheet2 c7="Win" or "no win" is just text
Sheet2 c8 is a number of wins or losses

Trying to figure best way to incorporate code to look at sheet1 , see if value in a78 is greater / or equals 0 and then update the sheet2 c7:c8 accordingly. Trying to create a streak tally. But I also need it to adjust accordingly For example 3 wins in row, and then loss - means sheet2 c7="no win" and sheet2 c8 =1

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!

My original thread stated that I needed cells c7 and c8 updated. This sheet is being updating from 2 different sheets. So yes instead of k - it should be c , according to original post. I was just trying to figure out the routine, but figured it out by reading from other questions.

Thanks again!