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.
|