On cell N4 the following formula/reference will be imputed, ='1'!C25. On the
next cell down N4 the following formula will be imputed ='2'!C25. On cell N5
the following formula will continue as ='3'!C25 .. and so on. As you can see
I am referencing a different sheets but the cell line remain the same. I
wanted to know if there is a way I can just drag the above cell down and for
it to continue with the same pattern. When I do it the '*" remains the same
and the C25 moves to c26,C27,C28 ..... and so on. I want the '*' to change to
1, 2 , 3, 4 and the C25 to remain fixed when I click the bottom right corner
and drag.

=INDIRECT("'"&ROW(N4)&"'!C25")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"trainer07" wrote in message
...
On cell N4 the following formula/reference will be imputed, ='1'!C25. On
the
next cell down N4 the following formula will be imputed ='2'!C25. On cell
N5
the following formula will continue as ='3'!C25 .. and so on. As you can
see
I am referencing a different sheets but the cell line remain the same. I
wanted to know if there is a way I can just drag the above cell down and
for
it to continue with the same pattern. When I do it the '*" remains the
same
and the C25 moves to c26,C27,C28 ..... and so on. I want the '*' to change
to
1, 2 , 3, 4 and the C25 to remain fixed when I click the bottom right
corner
and drag.