| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
exporting 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
exporting comments into a separate spreadsheet?
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 "Joe" wrote: I'd like to take all the comments from a single row, copy them and paste them into another spreadsheet, is that possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exporting a simple excel spreadsheet to ACT | Excel Discussion (Misc queries) | |||
| Exporting spreadsheet data | Excel Discussion (Misc queries) | |||
| Exporting Comments | Excel Discussion (Misc queries) | |||
| Exporting to CSV file with Chinese Characters in Spreadsheet | Excel Discussion (Misc queries) | |||
| Exporting Excel Charts in Separate Tabs | Excel Discussion (Misc queries) | |||
Linear Mode
