+ Reply to Thread
Results 1 to 3 of 3

Combine multiple rows in a specific column based on matching criteria? VBA solution?

  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    Valparaiso, FL
    MS-Off Ver
    Excel 2013
    Posts
    73

    Combine multiple rows in a specific column based on matching criteria? VBA solution?

    I am hoping for some VBA wizardry. I have 2 columns of data that need help. The first column (A) is the CRN # that identifies the class. The other column (D) “Class Days” shows the days of the week for that class. Sometimes a class can have multiple rows. I am looking for a macro that can look at the CRN in column A and if there are multiple rows, then combine all the class days.
    The code for each day of the week are as follows:
    MON=M
    TUE=T
    WED=W
    THU=R
    FRI=F
    SAT=S
    SUN=U
    The order is M T W R F S U
    For example CRN # 20808 has two rows. In the first row, column d, “class days” says T. Then the second row says TR. Is it possible for multiple rows to have the exact same data in the “class days” column? The final result would show in column d, “TR” for both rows. Is it also possible for the cells in column D to be in order of the days of the week?
    I have a sample attached. The master sheet contains all the data. The example sheet just shows the specific class I referenced above with the desired result.

    I appreciate your help!
    201620 Class Master Filter Final.xlsm

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,835

    Re: Combine multiple rows in a specific column based on matching criteria? VBA solution?

    Try
    Please Login or Register  to view this content.
    Last edited by jindon; 11-06-2015 at 07:20 PM. Reason: A small change.

  3. #3
    Registered User
    Join Date
    03-06-2014
    Location
    Valparaiso, FL
    MS-Off Ver
    Excel 2013
    Posts
    73

    Re: Combine multiple rows in a specific column based on matching criteria? VBA solution?

    I will check this first thing tomorrow...thank you for such a quick response! I appreciate your help so much!

+ 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. [SOLVED] Combine rows of data based on multiple criteria?
    By hopegriffin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2015, 12:54 PM
  2. Replies: 2
    Last Post: 06-09-2013, 08:50 PM
  3. Replies: 12
    Last Post: 02-21-2013, 12:55 PM
  4. Move Rows of Data from a Specific Column (Based on Matching Criteria) to a new Sheet
    By jordan1214 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2013, 02:30 AM
  5. [SOLVED] Mark or Delete Rows based on Matching Multiple Criteria in another worksheet
    By clearbluez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2012, 02:38 PM
  6. Combine Rows Based on Matching Cells in A
    By LeviThomason in forum Excel General
    Replies: 1
    Last Post: 06-28-2008, 04:27 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1