 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008exporting comments into a separate spreadsheet?
I'd like to take all the comments from a single row, copy them and paste them into another spreadsheet, is that possible? Joe, 2 ways. 1. Select the row with comments in and copy it and then go to the new sheet and Edit|Paste special and select comments. 1. A Macro which is over the top given the simplicity of 1. Right click the sheet tab, view code and paste this in Sub mariner() Sheets("Sheet1").Rows("1:1").Copy Sheets("Sheet2").Rows("1:1").PasteSpecial Paste:=xlPasteComments End Sub Mike > I'd like to take all the comments from a single row, copy them and > paste them into another spreadsheet, is that possible? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.