Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying excel comments
A workbook has a large number of worksheets asking identical questions but
for different products. I use the "comments" funtion to give guidance to the users. If I need to change a "comment" I would like it to automatically change on all the worksheets. The text of the question automatically changes because I have a utility worksheet from which all the subordinate wooksheets update (with a command like "=Utility!D11"). However although the text in all the subordinate cells change when the Utility worksheet is changed, the associated "comments" do not change when edited on the utility page. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying excel comments
It is very easy to refresh all the comments to match the ones on the Utility
worksheet. Select all the cells on the Utility sheet and copy them, then go to the subordinate sheets, select cell A1 and do a paste/special comments. This will refresh the cells with comments and leave alone the cells that do not have comments. -- Gary's Student "Pa Maher" wrote: A workbook has a large number of worksheets asking identical questions but for different products. I use the "comments" funtion to give guidance to the users. If I need to change a "comment" I would like it to automatically change on all the worksheets. The text of the question automatically changes because I have a utility worksheet from which all the subordinate wooksheets update (with a command like "=Utility!D11"). However although the text in all the subordinate cells change when the Utility worksheet is changed, the associated "comments" do not change when edited on the utility page. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying excel comments
To follow up, also, depending upon how many sheets you have and how
frequently you need to change comments, you could also create a macro by recording the select- copy - paste special actions, so that for future events you can just run the macro. Gary''s Student wrote: It is very easy to refresh all the comments to match the ones on the Utility worksheet. Select all the cells on the Utility sheet and copy them, then go to the subordinate sheets, select cell A1 and do a paste/special comments. This will refresh the cells with comments and leave alone the cells that do not have comments. -- Gary's Student "Pa Maher" wrote: A workbook has a large number of worksheets asking identical questions but for different products. I use the "comments" funtion to give guidance to the users. If I need to change a "comment" I would like it to automatically change on all the worksheets. The text of the question automatically changes because I have a utility worksheet from which all the subordinate wooksheets update (with a command like "=Utility!D11"). However although the text in all the subordinate cells change when the Utility worksheet is changed, the associated "comments" do not change when edited on the utility page. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying excel comments
Thank you very much Gary's Student, that solution will make the update
easier. However I was hoping there was some way to change the 20 subordinate worksheets without going to each one when I change the comment on the Utility Worksheet. "Gary''s Student" wrote: It is very easy to refresh all the comments to match the ones on the Utility worksheet. Select all the cells on the Utility sheet and copy them, then go to the subordinate sheets, select cell A1 and do a paste/special comments. This will refresh the cells with comments and leave alone the cells that do not have comments. -- Gary's Student "Pa Maher" wrote: A workbook has a large number of worksheets asking identical questions but for different products. I use the "comments" funtion to give guidance to the users. If I need to change a "comment" I would like it to automatically change on all the worksheets. The text of the question automatically changes because I have a utility worksheet from which all the subordinate wooksheets update (with a command like "=Utility!D11"). However although the text in all the subordinate cells change when the Utility worksheet is changed, the associated "comments" do not change when edited on the utility page. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Change the default size of comments in Excel? | Excel Discussion (Misc queries) | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) |