| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Update Links between cells of two worksheets in the same workbook
I have a link from a cell on Sheet B that refers to a cell on Sheet A. When I
add a row to Sheet A (and the cell gets 'bumped down'), my reference is off by that row? What can I do to automatically update this? How do I apply some type of relative reference so that no matter how many rows I add, the references shuffle with the new row position? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keep value from last update and don't ask to update links | Excel Discussion (Misc queries) | |||
| Update multiple worksheets | Excel Discussion (Misc queries) | |||
| linkingof charts in worksheets to cells | Excel Discussion (Misc queries) | |||
| update links - problem | Excel Discussion (Misc queries) | |||
| copying cells from other worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
