1.open all workbooks that are cross-linked with that cell.
2. if this cell is not referred by other workbooks,
right-click mousetcutpaste : to any convenient location you desired,
within the same sheet, if possible.

happy holidays...hohoho
"idoright69" wrote:

how do i keep a linked cell location the same when adding new row...