Paste Link Function
 

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!

Naive,

If you mean you're copying that formula, take out the $ signs. That makes
it a relative cell reference, not absolute as it now is.
--
Earl Kiosterud
www.smokeylake.com

"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!

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!