Pasting constant formula where referral sheet changes
Just in case it might look a little confusing, the first row number to be
returned is:
17 minus the last number.
So, your first column starts with 8,
17-9 = 8
For your second column to start with 9,
Change the -9 to -8
3rd column -6
4th column -11
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
Try this:
=INDEX(INDIRECT("'FP
"&INT(ROWS($1:4)/4)&"'!I:I"),17*(MOD(ROWS($1:1)-1,4)+1)-9)
And copy down.
--
HTH,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Nicole M." wrote in message
...
Just to see if I can make it more clea what I am trying to achieve, this
is
an example of a group of cells in the series:
='FP 1'!$I$8 ='FP 1'!$I$9 ='FP 1'!$I$11 ='FP 1'!$I$6
='FP 1'!$I$25 ='FP 1'!$I$26 ='FP 1'!$I$28 ='FP 1'!$I$23
='FP 1'!$I$42 ='FP 1'!$I$43 ='FP 1'!$I$45 ='FP 1'!$I$40
='FP 1'!$I$59 ='FP 1'!$I$60 ='FP 1'!$I$62 ='FP 1'!$I$57
='FP 2'!$I$8 ='FP 2'!$I$9 ='FP 2'!$I$11 ='FP 2'!$I$6
='FP 2'!$I$25 ='FP 2'!$I$26 ='FP 2'!$I$28 ='FP 2'!$I$23
='FP 2'!$I$42 ='FP 2'!$I$43 ='FP 2'!$I$45 ='FP 2'!$I$40
='FP 2'!$I$59 ='FP 2'!$I$60 ='FP 2'!$I$62 ='FP 2'!$I$57
='FP 3'!$I$8 ='FP 3'!$I$9 ='FP 3'!$I$11 ='FP 3'!$I$6
='FP 3'!$I$25 ='FP 3'!$I$26 ='FP 3'!$I$28 ='FP 3'!$I$23
='FP 3'!$I$42 ='FP 3'!$I$43 ='FP 3'!$I$45 ='FP 3'!$I$40
='FP 3'!$I$59 ='FP 3'!$I$60 ='FP 3'!$I$62 ='FP 3'!$I$57
|