Auto fill a formula

[drumn4life0789]

I have this formula in cells c7-c9 respectively

c7  =IF(ISTEXT(Team!E13),Team!E13,"")
c8  =IF(ISTEXT(Team!E23),Team!E23,"")
c9  =IF(ISTEXT(Team!E33),Team!E33,"")

I want to copy this formula down to c87. while increasing the column E on the team worksheet by 10 each time. Anyone know how.

 

[Yard]

Maybe

C7: =IF(ISTEXT(OFFSET(Team!E$13,(row()-row(C$7))*10,0),OFFSET(Team!E13,(row()-row(C$7))*10,0),"")

 

[Weaver]

or in code

Sub fillWithStepx10()
    Dim referToRow, formulaRow As Long
    referToRow = 13
    For formulaRow = 7 To 87
        Cells(formulaRow, "C").Formula = "=IF(ISTEXT(Team!E" & referToRow & "),Team!E" & referToRow & ","""")"
        referToRow = referToRow + 10
    Next
End Sub

 

[drumn4life0789]

Its says there is to many arguments for the formula. And I am kind of new to Excel so I couldn't figure out what that was doing, to try and fix it myself

 

[Yard]

Its says there is to many arguments for the formula. And I am kind of new to Excel so I couldn't figure out what that was doing, to try and fix it myself

oops, that's my fault for just typing it...

=IF(ISTEXT(OFFSET(Team!E$13,(ROW()-ROW(C$7))*10,0)),OFFSET(Team!E$13,(ROW()-ROW(C$7))*10,0),"")