View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sasa Stankovic Sasa Stankovic is offline
external usenet poster
 
Posts: 27
Default Copying comments from one cell to another, in a different spreadsheet

you can use "copy" on cell with comment and "Edit"-"Paste Special"-"Comment"
on cell which should receive comment.

"=!CmOrE!=" wrote in message
oups.com...
Hello Friends,

I would like to be able to write a comment in a cell, then have that
comment appear in another cell on a different spreadsheet within the
same workbook, though. Or within the same spreadsheet.

Is there a formula or some sort of formatting to allow for the type of
function?


Thanks in advance!!