+ Reply to Thread
Results 1 to 2 of 2

merge and reset a merge based on cell content

  1. #1
    Registered User
    Join Date
    05-25-2007
    Posts
    18

    merge and reset a merge based on cell content

    Trying to break this down into small chunks:
    Can anyone help with a macro or formula that combines the text and ">" symbol for each course grouping of text and resets itself for each blank cell between the last text from the previous course and the start of the next course.

    Example of data and output (column D) is attached.

    This will be used for several thousand courses on data migration, so manual is not an option.
    Thanks.
    Gene



    Similar to my last post, but I'm trying to do this in chunks.

    Thank you.
    Gene
    Attached Files Attached Files
    Last edited by salkovsg; 05-29-2007 at 03:52 PM. Reason: added file and reformatted.

  2. #2
    Forum Contributor
    Join Date
    01-21-2005
    Location
    Colorado
    MS-Off Ver
    2000,2003,2007
    Posts
    481
    Here are a couple of nested Do Loops that will accomplish what you are after.

    HTH

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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