Let me explain my issue with an example.
Lets say I have a link to a website , for example
http://www.microsoft.com/
in cell A1 which is formatted in a specific font and color and is also a
hyperlink. When I want to have the same information in cell A1 in other cells
say C3 and B5, I use =A1 in the cells C3 and B5.
But what happens is that only the information
http://www.microsoft.com is
copied to cells C3 and B5 and not the format of the text or the hyperlink.
How can I have the format also to be copied to cells C3 and B5 when
referencing.
Thanks in advance.
Vamshee