H
haleswd
I need lots of help people. I have a spreadsheet with about 20
worksheets. The first worksheet is the Master sheet. There is a
column in the other 19 worksheets that links to the master. I want
this column to copy the value, and also the formatting. When I say
formatting, I really mean the background colors,and text colors that
are on the master.
The master will be changed periodically, and I want the other 19 sheets
to auto update all of my formatting.
The formula that I have so far is this, but this does not copy the
formatting.
=IF(ISBLANK(MASTER!$A$4),"",MASTER!$A$4)
Can someone help me out. I would really appreciate it.
Thanks
worksheets. The first worksheet is the Master sheet. There is a
column in the other 19 worksheets that links to the master. I want
this column to copy the value, and also the formatting. When I say
formatting, I really mean the background colors,and text colors that
are on the master.
The master will be changed periodically, and I want the other 19 sheets
to auto update all of my formatting.
The formula that I have so far is this, but this does not copy the
formatting.
=IF(ISBLANK(MASTER!$A$4),"",MASTER!$A$4)
Can someone help me out. I would really appreciate it.
Thanks