I am trying to copy a formula that pertains to another sheet in the same
workbook. How can I do this?
=IF(I1="","",'Team Winners'!$AB7)
=IF(I2="","",'Team Winners'!$AB7)
=IF(I3="","",'Team Winners'!$AB7)
=IF(I4="","",'Team Winners'!$AB8)
=IF(I5="","",'Team Winners'!$AB8)
=IF(I6="","",'Team Winners'!$AB8)
Every third row I need to increase the row by one. If I just do a copy every
row goes up by one. I need to do this down to row 165.