LinkCellsFromTwoWorksheets.xls

<div>
Thanks guys! &nbsp;Perhaps we can recommend this to MS. &nbsp; Seems like it could be done through the app. rather easily.<br />
<br />
B.
</div>


Thanks guys!  Perhaps we can recommend this to MS.   Seems like it could be done through the app. rather easily.

B.

<div>
<div class="content wysiwyg-content">
EE Pros,<br />
<br />
Formatting Question. &nbsp;Is there a way (besides cut and paste), where I can reference a cell location from another sheet (same WB) and the new cell, with the referenced cell will inherit all of the formatting or characteristics of the referenced cell? &nbsp;That is to say, if I have a cell, let's say B10 in Sheet 2 that has a yellow background, 14 pt. font, Bold and underlined, with &quot;comments&quot;, and I reference it into A10 on Sheet 1 (i.e. =Sheet2!B10), can I get it to show up with the same formatting and comments?<br />
<br />
Hopefully the answer is &quot;yes&quot;........... ;-)<br />
<br />
B.
</div>
</div>


EE Pros,

Formatting Question.  Is there a way (besides cut and paste), where I can reference a cell location from another sheet (same WB) and the new cell, with the referenced cell will inherit all of the formatting or characteristics of the referenced cell?  That is to say, if I have a cell, let's say B10 in Sheet 2 that has a yellow background, 14 pt. font, Bold and underlined, with "comments", and I reference it into A10 on Sheet 1 (i.e. =Sheet2!B10), can I get it to show up with the same formatting and comments?

Hopefully the answer is "yes"........... ;-)

B.

Excel Reference Cells and Characteristics

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.