Exact Copy of Linked Cells in Excel

  • Thread starter Thread starter hoy13
  • Start date Start date
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
 
Hi
formulas (that is your linked cell) can only return values. Therefor
formats are not transfered.
 
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
 
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)
 
Back
Top