View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pa Maher Pa Maher is offline
external usenet poster
 
Posts: 2
Default 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.