#1   Report Post  
Posted to microsoft.public.excel.misc
Sam Sam is offline
external usenet poster
 
Posts: 699
Default collating comments

Hi, I wonder if any one can help , I have a row of cells (a2-ab2)and each one
will have a comment placed in them using the insert a comment tool on the
tool bar, is there any way to collate them say in a new sheet or even into a
Microsoft word sheet, can it be done?.
Thanks in advance for any ideas.
Sam.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default collating comments

Take a look at Debra Dalgleish's site:
http://contextures.com/xlcomments03.html#CopyToWord



Sam wrote:

Hi, I wonder if any one can help , I have a row of cells (a2-ab2)and each one
will have a comment placed in them using the insert a comment tool on the
tool bar, is there any way to collate them say in a new sheet or even into a
Microsoft word sheet, can it be done?.
Thanks in advance for any ideas.
Sam.


--

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
collating data wildauk Excel Discussion (Misc queries) 2 May 25th 08 11:50 PM
Collating/ Summarising worksheets James Excel Discussion (Misc queries) 1 August 10th 07 02:54 AM
Collating date from a number of worksheets into one Rooster Excel Discussion (Misc queries) 3 July 23rd 06 08:09 PM
collating Data Paul Cooke Excel Discussion (Misc queries) 0 December 5th 05 04:29 PM
Collating information in a different location tom300181 Excel Discussion (Misc queries) 3 August 4th 05 09:03 AM


All times are GMT +1. The time now is 05:30 PM.

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

About Us

"It's about Microsoft Excel"