View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default Comment Function & Auto Filter

This is different from what you had described earlier.

Anyway, choose Edit-Go To-Special-Visible Cells only and the Copy and do
Paste Special...

"Chilired" wrote:

I have used comments before and never had an issue, however with this
spreadsheet I am encountering the problem of comments attaching to different
cells.

When using the auto filter function, inserted a comment for to B6, copied,
then Paste Special/Comment to the remaining cells in the sorted information.
When I use the auto filter again the information appears in all my cells
instead of the ones that selected in the sort. Any suggestions on what I am
doing incorrectly?

Thanks,

"Chilired" wrote:

I created a spreadsheet (Excel 2003) that has multiple comments; when the
information is sorted the comments are seperated from the original text. Is
there a way to make the comments "stick" with the information once it is
sorted? By the way the sheet will be protected and placed on the web.

Working on a tight deadline would appreciate a reply asap.

Thanks,