Excel sheets

C

Cory

I am trying to link worksheets in a way that allows a sheet to be auto
updated when I add a comment or format the color of a cell. Is this possible?
So far, only the text gets updated, not the insertion of a comment, nor the
format of cell color. Please help. Thanks
 
F

FloMM2

Cory,
Once you have linked the cell, select the cell, copy.
The linked cell, select cell, edit, paste special, select formats and
comments.
That should do it.
hth
 
Top