Extracting Comments?
Is it possible to do the following:
I want to be able to extract the information contained within a cells comment. e.g. A1 = Testing... (Within the comments on A1, it contains the following Test 1, Test 2, Test 3). What I need to be able to do is extract all of the information contained in any cell that has a comment and show the data as per example below: B C 1 Testing Test 1 2 Test 2 3 Test 3 Therefore it will pick out the first cell with a comment and show by that cells data, all of the comments that are applied against the one cell. Appreciate any help anyone can offer - if you need an example spreadsheet, please let me know. Many Thanks, Al ( ) |
Extracting Comments?
There's some sample code on the following page that will extract all the
comment text from the active sheet: http://www.contextures.com/xlcomment...ml#CopyToSheet MrAlMackay wrote: Is it possible to do the following: I want to be able to extract the information contained within a cells comment. e.g. A1 = Testing... (Within the comments on A1, it contains the following Test 1, Test 2, Test 3). What I need to be able to do is extract all of the information contained in any cell that has a comment and show the data as per example below: B C 1 Testing Test 1 2 Test 2 3 Test 3 Therefore it will pick out the first cell with a comment and show by that cells data, all of the comments that are applied against the one cell. Appreciate any help anyone can offer - if you need an example spreadsheet, please let me know. Many Thanks, Al ( ) -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com