Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print sheets in Excel without blank sheets after page | New Users to Excel | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
populating sheets based on data from parent sheets | Excel Discussion (Misc queries) |