Linking cells within workbook with ALL formating

A

ATworker

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.
 
S

Sheeloo

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...
 
G

Gord Dibben

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

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


Gord Dibben MS Excel MVP
 
A

ATworker

Thanks. I will try that when I have time.

Sheeloo said:
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top