I know how to link cells in different sheets in the same workbook but I
cannot get all of the formatting to link. Two worksheets. One is a subset of
the other. My "data" in all cells are either alpha or numerical or both in
the same cell. I simply want any changes I make to the master to change
(mimic or mirror exactly) in the subset sheet including formatting such as
bold, letter colors etc. The characters will change (i.e. value) but the
formatting is lost. Is there a way to do this? Please advise.

Formatting can not be transferred using formulas or links...

You need to write a macro to copy values and formats... and then either
manually execute the macro or tie to a worksheet event (like change) to fire
it automatically...

"ATworker" wrote:

I know how to link cells in different sheets in the same workbook but I
cannot get all of the formatting to link. Two worksheets. One is a subset of
the other. My "data" in all cells are either alpha or numerical or both in
the same cell. I simply want any changes I make to the master to change
(mimic or mirror exactly) in the subset sheet including formatting such as
bold, letter colors etc. The characters will change (i.e. value) but the
formatting is lost. Is there a way to do this? Please advise.

Thanks. I will try that when I have time.

"Sheeloo" wrote:

Formatting can not be transferred using formulas or links...

You need to write a macro to copy values and formats... and then either
manually execute the macro or tie to a worksheet event (like change) to fire
it automatically...

"ATworker" wrote:

I know how to link cells in different sheets in the same workbook but I
cannot get all of the formatting to link. Two worksheets. One is a subset of
the other. My "data" in all cells are either alpha or numerical or both in
the same cell. I simply want any changes I make to the master to change
(mimic or mirror exactly) in the subset sheet including formatting such as
bold, letter colors etc. The characters will change (i.e. value) but the
formatting is lost. Is there a way to do this? Please advise.

Only if you apply the same conditional formatting to source and destination
cells.

Elsewise............no.


Gord Dibben MS Excel MVP

On Mon, 16 Mar 2009 13:01:04 -0700, ATworker
wrote:

I know how to link cells in different sheets in the same workbook but I
cannot get all of the formatting to link. Two worksheets. One is a subset of
the other. My "data" in all cells are either alpha or numerical or both in
the same cell. I simply want any changes I make to the master to change
(mimic or mirror exactly) in the subset sheet including formatting such as
bold, letter colors etc. The characters will change (i.e. value) but the
formatting is lost. Is there a way to do this? Please advise.