Auto fill a formula

drumn4life0789

New Member
Joined
Mar 17, 2009
Messages
2
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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Maybe

C7: =IF(ISTEXT(OFFSET(Team!E$13,(row()-row(C$7))*10,0),OFFSET(Team!E13,(row()-row(C$7))*10,0),"")
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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),"")
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,266
Members
448,558
Latest member
aivin

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top