[First posting was to wrong Group]

XL 2003

Below is a summary of sheet information


SHEET NAME CELL AMOUNT LINK
Summary by deal B32 4,000,000.00 B32


The (Sub Address) Link "B32" on Sheet "Summary by Deal" is calculated
by SubAddress = SHEET NAME + CELL (was B32).


If the cell positions on Sheet "Summary by Deal" change then this Link
will fail.


I realize that I need to re-calculate the Link by re-doing
SubAddress = SHEET NAME + CELL (now B33).


More important and the challenge:


How do I get the CELL value to change from B32 to B33 when the row is
inserted in Sheet "Summary by Deal?"


Is there a smarter/better way to solve?


TIA EagleOne