Excel sheets
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 -- Cory Kav |
Excel sheets
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 "Cory" wrote: 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 -- Cory Kav |
All times are GMT +1. The time now is 06:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com