Exact Copy of Linked Cells in Excel

H

hoy13

I have a Main information Sheet that links to corresponding othe
sheets. When I type into the main cell, it will link the letter that
type, but bold portions and fill color does not link. How can I hav
an exact copy of my main cell? (I used Paste Special-Paste Link t
link the cell)

I attached an example of what it is doing. "Main Sheet" is what I wan
my linked sheet to look like. "Linked Sheet" depicts what actuall
happens with the link.

Thanks,
Jo
 
F

Frank Kabel

Hi
formulas (that is your linked cell) can only return values. Therefor
formats are not transfered.
 
F

Frank Kabel

Hi
also user defined functions in VBA can only transfer values. The only
way would be to use the worksheet_change event like the following:
- check if your value in the main cell has changed
- if yes transfer the value to all cells in the sub sheets
- copy the current format

But only a format change in your target cell would not trigger this
event. Therefore only if you change the value the formats are copied.
So I would preformat the target cells or/and use conditional format
 
B

booshi

Hi, I also have this problem before. I found that the cell has "memory". If
it was a formula before then it returns formula. If it was a value, then
return value. (Pls check .formula in vba help)
 
Top