Trouble with Formula
"GregR" wrote in message
oups.com...
I have the following formula in C9
=OFFSET(Connie!$O$9,0,(ROW()-9)*2)
which is then copied to next 4 row and formula repeats with an
incremental offset, so that in Row 14 would be
=OFFSET(Connie!$O$9,1,(ROW()-14)*2)
and so on. A Few more examples
R19 would be =OFFSET(Connie!$O$9,3,(ROW()-19)*2)
R24 would be =OFFSET(Connie!$O$9,4,(ROW()-24)*2)
R29 would be =OFFSET(Connie!$O$9,5,(ROW()-29)*2)
R34 would be =OFFSET(Connie!$O$9,6,(ROW()-34)*2)
Notice how every fifth row the row offset increments by 1, and
the column offset by +5.
I can't figure out how to increment these variables accordingly. If
anyone can help with an amended formula or better yet with code, it
would make my life a whole lot easier. I have over 5000 rows to input
these formulae and copy down 4 rows. TIA
|