Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2003

    Unanswered: Capturing information seperated by empty cells?

    I need to copy notes on different "opportunities" underneath the corresponding opportunity name in another worksheet. The name and order of the opportunites is the same but one list has alot more information so they are not the same line numbers.

    A seperate cell is used for each note. The note is three cells long, for a date, name of the person who made the note, and content of the note.

    Some "opportunities" have several notes, others have none. If there are no notes, the "Notes" heading will not even appear.

    There are other values underneath the opportunity name, but the name is a 12 point font while the other info is 8 pt font.

    So basically I need to find an opportunity name, if there is a "notes" field below it then the script needs to capture that heading and determine how many notes are under that heading, perhaps searching on if that type is numeric/date. It captures the notes heading with the info, finds the opportunity in the other worksheet, creates the appropriate number of lines in another record, and dumps the data in the new lines.

    If the script runs into another 12 pt font then thats means another opportunity has been named, and it needs to look for notes on that opportunity.

    Im not sure how to qualify this kind of search, if you read this far congratulations!

    Opportunity name in 12 pt font
    Random information
    More random information
    Date Created Creator: Note:
    7/30/2003 blah blah blah

    7/30/2003 blah blah blah

    7/30/2003 blah blah blah
    Last edited by goodsboy; 09-04-03 at 02:01.

Posting Permissions

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