Linking Texts from on sheet to another while maintaining formattin
 

I am trying to link values from a master list to seperate sheets, so that I
only have to edit the master list and all of my other sheets change
accrodingl. I can do this but the only problem I am currently having is I
can't get it to recognize the formatting changes such as strike through or
font color changes. Is there anyway that I can get this to happen so I don't
have to edit all sheets?

Linking Texts from on sheet to another while maintaining formattin
 

Nope... You can link values but you can not link formats.
--
HTH...

Jim Thomlinson


"merritaf" wrote:

I am trying to link values from a master list to seperate sheets, so that I
only have to edit the master list and all of my other sheets change
accrodingl. I can do this but the only problem I am currently having is I
can't get it to recognize the formatting changes such as strike through or
font color changes. Is there anyway that I can get this to happen so I don't
have to edit all sheets?

Linking Texts from on sheet to another while maintaining forma
 

Jim....thanks for the answer.....even if it wasn't what I wanted to hear.


"Jim Thomlinson" wrote:

Nope... You can link values but you can not link formats.
--
HTH...

Jim Thomlinson


"merritaf" wrote:

I am trying to link values from a master list to seperate sheets, so that I
only have to edit the master list and all of my other sheets change
accrodingl. I can do this but the only problem I am currently having is I
can't get it to recognize the formatting changes such as strike through or
font color changes. Is there anyway that I can get this to happen so I don't
have to edit all sheets?