Paste Link Function

  • Thread starter naiveprogrammer
  • Start date
N

naiveprogrammer

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

Earl Kiosterud

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.
 
A

Andy Wiggins

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