Copy/paste links

J

Jason Harmer

I have one row of links, ie cell D51 = '[Fin Spt.xls]
Summary page'!$I$49, cell E51 = '[Fin Spt.xls]Summary
page'!$J$49, cell F51 = '[Fin Spt.xls]Summary page'!$K$49,
and so on. I want to copy that row, paste it in rows 52-
58, but I want the links to follow suit (49 in row 51, 50
in row 52, etc). any help?
 
D

drabbacs

Take out the $'s before copying and pasting. The dollar
signs fix the cell reference as an absolute reference.
 
T

TesnoBay

How about links from month to month spreadhseets into an EOY. I have 12
seperate sheets for each month. I then summarize that into an EOY
sheet. I would love to be able to "drag" for example =Jan!B21, and have
it change to =Feb!B21.

Is this possible?
 
Top