#1   Report Post  
LilLiz
 
Posts: n/a
Default Comments

How do you copy comments from 1 Excel workbook to another? I am having a
problem doing this. I would like to take information that includes comments
from 1 workbook and paste the information with the comments into another
workbook, I get the data from the cells but not the comments. How do I do
this???
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Select your cell with the comment.
Edit|copy

Go to the other location in that other worksheet/workbook.
Edit|paste special|Check comments

LilLiz wrote:

How do you copy comments from 1 Excel workbook to another? I am having a
problem doing this. I would like to take information that includes comments
from 1 workbook and paste the information with the comments into another
workbook, I get the data from the cells but not the comments. How do I do
this???


--

Dave Peterson
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

From your later post, I see that you don't just want to copy the comments.

I don't recall ever seeing edit|copy, edit|paste not paste the comments.

Dave Peterson wrote:

Select your cell with the comment.
Edit|copy

Go to the other location in that other worksheet/workbook.
Edit|paste special|Check comments

LilLiz wrote:

How do you copy comments from 1 Excel workbook to another? I am having a
problem doing this. I would like to take information that includes comments
from 1 workbook and paste the information with the comments into another
workbook, I get the data from the cells but not the comments. How do I do
this???


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I protect my comments from being edited by another user? Laura L Excel Discussion (Misc queries) 5 March 16th 05 05:31 PM
Paste Link - Cell Comments get lost Wayne H Excel Worksheet Functions 2 February 26th 05 11:51 PM
Printing Comments in Excel 2003 Sulinda Excel Worksheet Functions 5 February 25th 05 09:09 PM
How do I export comments into another excel column as cell content Hernan Excel Worksheet Functions 1 February 25th 05 02:17 PM
Can Comments be automatically converted to text cell values? tomdog61 Excel Discussion (Misc queries) 1 January 23rd 05 09:38 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"