Create a small macro to remove data from excel sheet

I have a csv file and I need to export one part of the data file out in a certain order. the sheet is the results of a card game. The winners are clearly written in 1 column. I need the macro to show me the results of a certain pattern that I want looking at. If a certain hand wins 3 times in a row we will bet that next time that hand will NOT win if . if it does not win it is marked as a W ( as we actually won ) if the hand does win it is marked as a L ( as we actually lost. example :- Hands :- there are 4 possible winners ..hearts clubs diamonds and spades if we get this scenario game 1 hearts game 2 hearts game 3 hearts Game 4 we would bet here that hearts will NOT win again so the macro will look for 3 winning hands of the same suit and then check the next result , and show me the results for the day.