Formatting when referencing?

[Guest]

I am referecing cells b/w multiple sheets with the "Master" sheet holding all
of the data. So the referencing in Sheet 2 looks like "=MASTER!A1", but the
problem is that when the information is placed into Sheet 2 the formatting
doesn't follow. So the Master Sheet may have a Blue font and the font in
Sheet 2 will be black. Any help?

 

[Guest]

It doesn't matter if the reference is within a worksheet or between worksheets.

Most formatting does not carry-over.

 

[Peo Sjoblom]

You would need an event macro for this, here's an example

http://tinyurl.com/dqq3r

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon