I am referecing cells b/w multiple sheets with the quot;Masterquot; sheet holding all
of the data. So the referencing in Sheet 2 looks like quot;=MASTER!A1quot;, 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
Formulas can't return formatting like this.
You may be able to use some sort of macro that copies and pastes???
Beard wrote:
gt;
gt; I am referecing cells b/w multiple sheets with the quot;Masterquot; sheet holding all
gt; of the data. So the referencing in Sheet 2 looks like quot;=MASTER!A1quot;, but the
gt; problem is that when the information is placed into Sheet 2 the formatting
gt; doesn't follow. So the Master Sheet may have a Blue font and the font in
gt; Sheet 2 will be black. Any help?
gt; --
gt; Brad
--
Dave Peterson
- Jul 16 Mon 2007 20:38
Keeping the format when referencing cells?
close
全站熱搜
留言列表
發表留言