Formatting when referencing?
 

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?

--
Brad

Formatting when referencing?
 

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

Most formatting does not carry-over.
--
Gary's Student


"Beard" wrote:

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?

--
Brad

Formatting when referencing?
 

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

http://tinyurl.com/dqq3r

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"Beard" wrote in message
...
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?

--
Brad