ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel sheets (https://www.excelbanter.com/excel-worksheet-functions/178376-excel-sheets.html)

cory

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

FloMM2

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