I know it's easy to display the contents of a cell in another sheet by using, for example, a forumla like this:
='Sheet 1'!J30
But I was wondering if there is a way to display everything from the cell (the fill, the colour of the text etc as well as the actual numeric value in the cell)
Many thanks,
Jack
Bookmarks