Moving Linked Cells

[Scott Cholewinski]

I have a excel spreadsheet that has many cells that are linked from one worksheet to another using "=". Is there a way of moving the linked cells and having the link move with it.

For example let say worksheet "A" cell "A1" is linked to worksheet "B" cell "C2". It is linked by typing in "=" in cell "A1" on worksheet "A", then clicking on cell "C2" on worksheet "B". However I now want to move cell "C2" on worksheet "B" to cell "D5" however have the link from worksheet "A" move with it. so that cell "A1" on worksheet "A" is now linked to cell "D5" on worksheet "B". sigh, confusing enough for you.

[oldchippy]

Hi,

Try selecting the cells with the formulas and then go to Edit > Find, type in =
then Replace and type ==

Then copy the formulas over and do the reverse of the above