Formatting when referencing?

[Beard]

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

[Gary''s Student]

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

[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




"Beard" <[email protected]> wrote in message
news:[email protected]...
>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