+ Reply to Thread
Results 1 to 4 of 4

transferring comments to a neighbouring cell

  1. #1
    Registered User
    Join Date
    09-16-2008
    Location
    England
    Posts
    1

    transferring comments to a neighbouring cell

    I have a spreadsheet with lots of comments and have decided that I would prefer to have the contents of the comments in a cell in a neighbouring column. Is there a way that I can transfer all the comments without copy and pasting them seperately. Thanks

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    http://exceltips.vitalnews.com/Pages..._to_Cells.html
    gives this code
    Please Login or Register  to view this content.
    just tried it and it works a treat
    just select all cells in the column with comments as a contiguous range,and run code
    Last edited by martindwilson; 09-16-2008 at 05:32 PM.

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    You would need code.

    See if link helps

    http://www.contextures.com/xlcomment...l#CopyAdjacent

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577
    Without code, I think this works
    1. Highlight all the cells you have comments in that you want in the new column. Copy
    2. Go to the first cell in the range where you want to copy the comments.
    3. Paste Special > Comments
    4. Go back to original cells, highlight them, right click and Delete Comments.

    Does that work for you?
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to copy cell comments to a new cell?
    By MyBrainhURTS in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-04-2009, 11:20 AM
  2. How to Extract Cell "Comments"
    By CharlieO in forum Excel General
    Replies: 2
    Last Post: 03-31-2008, 07:06 PM
  3. Inserting a row does not increment reference in cell
    By diguerd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2008, 01:26 PM
  4. Replies: 2
    Last Post: 03-07-2008, 08:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1