drewmedcap
New Member
- Joined
- Jun 4, 2008
- Messages
- 1
I have defined a name range of LoanAmount =E389 which currently is a value of $9,028,000 in a section of my worksheet. I am also writing a summary paragraph of the deal overview at the top of my worksheet as a text narrative but want to insert the definition LoanAmount in the body of the text and have it return $9,028,000 within the sentence. All the text is in one cell. If I tweak the drivers behind LoanAmount, I would like for the new value to dynamically update in my narrative. How do I insert a defined name in a string of text? Is this possible. Thank you very much for your help! <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:PersonName w:st="on">Drew Hayes</st1:PersonName><o></o>
<o> </o>
<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:PersonName w:st="on">Drew Hayes</st1:PersonName><o></o>