+ Reply to Thread
Results 1 to 4 of 4

Getting data from comments and splitting it via vba

  1. 12-19-2013, 08:44 AM #1
    ad9051
    ad9051 is offline
    Forum Contributor
    Join Date
    12-01-2010
    Location
    Southampton, England
    MS-Off Ver
    Excel 2007
    Posts
    303

    Getting data from comments and splitting it via vba

    Hello Excel forum,

    First and foremost thanks for taking the time to look at my problem, I have some data contained within some comments, but I want to extract and split the data so I can actually perform some data analysis on it. I have attached an example document.

    Please feel free to take a look.

    Many thanks in advance!

    Regards Alan
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-19-2013, 09:07 AM #2
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Getting data from comments and splitting it via vba

    Hi Alan,
    try it
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 12-19-2013, 09:14 AM #3
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,925

    Re: Getting data from comments and splitting it via vba

    One way:

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 12-19-2013, 09:19 AM #4
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,925

    Re: Getting data from comments and splitting it via vba

    Slight modification (picked up from nilem's approach):

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I combine splitting data into files then splitting the new files data into multiple
    By Lauraguthrie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2013, 01:18 PM
  2. After splitting data in one column using delimiter, only some data splits!
    By polutropa in forum Excel General
    Replies: 2
    Last Post: 01-29-2013, 02:46 PM
  3. Replacing the existing Data of workbooks on splitting Data in a Master workbook
    By anchuri_chaitanya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2012, 11:59 AM
  4. Comments border disappeared, don't display when mouse dragged over Comments
    By thesilverfox in forum Excel General
    Replies: 3
    Last Post: 08-14-2009, 07:22 AM
  5. Cell Comments-Is possible to search for data in comments?
    By dmm129 in forum Excel General
    Replies: 3
    Last Post: 10-28-2005, 03:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1