How do I copy the cell-content plus its comment to another cell ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to copy the content of a cell plus its cell comment to another cell
in the Workbook. I know I can copy the comtent by a simple =$A$3 for example,
but the comment is the tricky issue.
 
Hi

Copy the cell. Right-click on destination cell, and select Paste Special
from drop-down menu. Check Formulas (or Values), and click OK to paste
contents of cell. With destination cell jet activated, right-clik again on
it, and activate PasteSpecial wizard again. Check Comments, and click OK.

Arvi Laanemets
 
Hi Arvi..thakns for this help. But I'm looking for an automated way to do
that (or a dynamic copy functions as"=$A$3" is.) It shouldn't be manual.

Any idea ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Import Comments 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copying a Picture From Cell Comment 0
Link Cells with Comments 1
Conditional fomatting for cells containing a Comment 7
Copy cells in Excel 1
How do I export comments into another excel column as cell content 1
HOW DO I COPY ALL DATA (INC COMMENTS)FROM 1 WORKBOOK TO ANOTHER 3

Back
Top