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