Auto fill a formula

drumn4life0789

New Member
I have this formula in cells c7-c9 respectively
Code:
``````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.

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Yard

Well-known Member
Maybe

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

Weaver

Well-known Member
or in code

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

New Member
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

Well-known Member
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),"")

Replies
8
Views
241
Replies
5
Views
567
Replies
3
Views
251
Replies
25
Views
2K
Replies
4
Views
428

1,190,896
Messages
5,983,441
Members
439,843
Latest member
PlanetFitness

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back