1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel - Combine information under one student ID

Discussion in 'Business Applications' started by Realtchr, Jul 22, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. Realtchr

    Realtchr Thread Starter

    Joined:
    Jul 22, 2012
    Messages:
    2
    I have a school database where student information is organized under a student ID. The problem I have is that some students have only one parent contact and others have multiple parents and multiple contacts. What I need to do is figure out a macro that will move the different parental contact information under one student ID by adding columns as in the example I've attached (sheet2). If there are different phone numbers then I need to show these (up to 4 different phone #'s are possible for each parent). I'm pretty new to macros and don't really know how to even begin. -TIA
     

    Attached Files:

  2. 20_2_Many

    20_2_Many

    Joined:
    Jun 29, 2012
    Messages:
    518
    Hope this helps.
    Your Student list would go into the Students sheet Col A: - M:
    Then you run the Combine Contacts macro.
    It will:
    sort the Student IDs (Primary Sort) and Contact (Secondary Sort),
    copy Student A-M to Contacts A-M,
    Combine multiple contacts from Students into Contacts (Contact_2, Contact_3 - (Max of 4 for the layout) on Contact Sheet
    Remove the Duplicate (multiple Row entries) Student IDs from Contact Sheet
    Leaving a single contact row for each ID in Contact Sheet and Student Sheet untouched.
     

    Attached Files:

  3. Realtchr

    Realtchr Thread Starter

    Joined:
    Jul 22, 2012
    Messages:
    2
    Wow, thank you so much!! It looks like this did exactly what I wanted. I especially like the way you broke down what you had the macro do. Now I need to get into the code a little bit to see how you did it. Thanks again!
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1062122