How to force a cell value to change if Linked cell moves?

[EagleOne]

[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

 

[EagleOne]

I must be taking Moron pills!

I should just set the CELL value to the Cell address "Summary by Deal".
Any better ideas?

EagleOne

 

[Dave Peterson]

If this is for a hyperlink, check that other post.

I must be taking Moron pills!

I should just set the CELL value to the Cell address "Summary by Deal".
Any better ideas?

EagleOne

[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