software

The issue I'm having is formatting of linked text. I'm not even sure if
this is possible using excel.

I have 3 worksheets within a workbook. One sheet has a few hundred cell
full of text that I can move around. A second sheet links the data
utilizing the following formula: =INDIRECT(quot;data!b2quot;) to the third
sheet.

The reason I need to do the indirect data link is to maintain cell
references. I need to move the text around but keep the cell references
the same.

What I'd like to do is format the text in the first sheet (bold,
italics, color, etc) and have this formatting appear on the final
sheet. Right now when I format the text, it doesn't appear on the final
sheet.

I'm not sure if this is even possible in excel but I figured if it
were, someone here would probably know.

Thank you in advance for any assistance you can offer.--
vman252
------------------------------------------------------------------------
vman252's Profile: www.excelforum.com/member.php...oamp;userid=17612
View this thread: www.excelforum.com/showthread...hreadid=521432You have a response to your post in .excel.

vman252 wrote:
gt;
gt; The issue I'm having is formatting of linked text. I'm not even sure if
gt; this is possible using excel.
gt;
gt; I have 3 worksheets within a workbook. One sheet has a few hundred cell
gt; full of text that I can move around. A second sheet links the data
gt; utilizing the following formula: =INDIRECT(quot;data!b2quot;) to the third
gt; sheet.
gt;
gt; The reason I need to do the indirect data link is to maintain cell
gt; references. I need to move the text around but keep the cell references
gt; the same.
gt;
gt; What I'd like to do is format the text in the first sheet (bold,
gt; italics, color, etc) and have this formatting appear on the final
gt; sheet. Right now when I format the text, it doesn't appear on the final
gt; sheet.
gt;
gt; I'm not sure if this is even possible in excel but I figured if it
gt; were, someone here would probably know.
gt;
gt; Thank you in advance for any assistance you can offer.
gt;
gt; --
gt; vman252
gt; ------------------------------------------------------------------------
gt; vman252's Profile: www.excelforum.com/member.php...oamp;userid=17612
gt; View this thread: www.excelforum.com/showthread...hreadid=521432

--

Dave Peterson