Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic Changes to Linked Cells
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
embedding worksheet cells in another worksheet | Excel Discussion (Misc queries) | |||
Preserving hyperlinks in linked cells | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
inserting row into linked cells | Excel Worksheet Functions |