| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to force a cell value to change if Linked cell moves?
[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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to force a cell value to change if Linked cell moves?
I must be taking Moron pills!
I should just set the CELL value to the Cell address "Summary by Deal". Any better ideas? EagleOne EagleOne wrote: [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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to force a cell value to change if Linked cell moves?
If this is for a hyperlink, check that other post.
EagleOne wrote: I must be taking Moron pills! I should just set the CELL value to the Cell address "Summary by Deal". Any better ideas? EagleOne EagleOne wrote: [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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| No change in result cell | Excel Worksheet Functions | |||
| Cell Change Color - Need Help | New Users to Excel | |||
| Change sheet name on linked cell by dropdown box | Excel Worksheet Functions | |||
Linear Mode
