drumn4life0789
New Member
- Joined
- Mar 17, 2009
- Messages
- 2
I have this formula in cells c7-c9 respectively
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.
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.