mirroring cell contents on another sheet
Posted by Todd on January 24, 2002 11:07 AM
I am trying to find a way to exactly mirror the contents of a cell on one sheet to another. I not only want to duplicate the text but it's formatting as well. This needs to happen automatially without the user having to manually copy and paste the text formatting of the source cell.
In other words I would like to enter a formula into cell (sheet2!A56) that would cause it to always contain the text and formatting of (sheet1!A1) including any bolded or italicized text.