Normally one captures the content within a cell of another cell via a very simple reference formula. For example
entered into a cell (let's say B2) will display the contents of the first cell of the Excel worksheet (A1) in the cell entered (B2).Please Login or Register to view this content.
Is there a way to capture all of the formatting of A1 similarly and have it display in B2 as well as the content?
I should mention that a non-VBA solution is preferred but not mandatory.
Bookmarks