If you put a $ before the A and another before the 25 it will make that cell
an absolute reference - see below
=PH1!$A$25
Then copy it and you should be all set.

"Rizing" wrote:

My formula is =PH1!A25 for one cell on my worksheet. I need the same formula
in the other cells in my column. When I do that I get the following in the
cells I pasted to....

=PH1!A26
=PH1!A27
=PH1!A28 and so on.

Is there a way to copy the formula and have it count like this....

=PH2!A25
=PH3!A25
=PH4!A25 and so on.

Any and all help is very much appreciated.
=PH1!A25