What formula do you have in cell A1 on sheet 1? I've put =Sheet2!B1 and if I
insert columns in Sheet 2 the formula changes to =Sheet2!F1

Is that what you need?

"Donna Silva" wrote:

I eed to find a way to link to a cell and have the link follow that cell
should it chanage due to editing of the spreadsheet. For example in
Spreadsheet 1 I linked cell A1 to cell B1 in spreadsheet 2. Then I made
changes in spreadsheet 2 and the contents of cell B1 are now located in cell
B5. How do I get the link in spreadsheet 1 cell A1 to automatically change
to be linked to cell B5 in spreadsheet 2?

The version of excel that I have automatically puts in the "$" before the
cell letter and number. I have done a test by taking out the "$" to see if
it would follow the original cell and it does not.
Any ideas?
--
Donna Silva
Finance Director
City of Rio Vista