Take the $ signs out of "=Monthly!$A$27" so it becomes "=Monthly!A27", then
copy.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"naiveprogrammer" wrote in
message ...
Is there a way to be able to copy the paste link function where the cell
below automatically increments the cell number? (I.e. "=Monthly!$A$27"
copy
to cell below "=Monthly!$A$28")

Thanks!