Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: Excel - Combine information under one student ID


(!)

Realtchr's Avatar
Realtchr Realtchr is offline
Member with 2 posts.
THREAD STARTER
 
Join Date: Jul 2012
22-Jul-2012, 08:29 AM #1
Solved: Excel - Combine information under one student ID
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
File Type: xls sample.xls (30.5 KB, 33 views)
20_2_Many's Avatar
20_2_Many 20_2_Many is offline
Member with 506 posts.
 
Join Date: Jun 2012
22-Jul-2012, 11:35 AM #2
Student_Contacts_Combined
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
File Type: xls Students_Contacts.xls (40.0 KB, 38 views)
Realtchr's Avatar
Realtchr Realtchr is offline
Member with 2 posts.
THREAD STARTER
 
Join Date: Jul 2012
22-Jul-2012, 09:02 PM #3
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

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
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.


Tags
combine data, excel macro needed

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑

Content Relevant URLs by vBSEO 3.3.2