How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9654
Experience:  Bachelor of Science - Engineering Consultant
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

I have a master list of people (approx 2500) in excel and then

Customer Question

I have a master list of people (approx 2500) in excel and then I have a those people broken down into groups in other excel files (40 excel files). What I would like to do is have a master file with the persons name and in the next several columns the groups they are in. How should I go about starting this? Thank you
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  Chris L. replied 2 years ago.
Hello and thank you for using Just Answer.

This may be kind of difficult to explain especially since I cannot see the spread sheets.

Here is how I would do it. (this is based on what you have described.

I would first start a new sheet. I would copy the 2500 names. Next I would create columns for group 1 group 2 etc and I would paste the names under the corresponding group.

This way when you sort A-Z You can look at the master column and then look over to the right to see what group they are in. I made you a quick example which you can download here:
http://wikisend.com/download/239724/example.xls

Microsoft access would probably be the better choice to manage all the information in the 40 spreadsheets.

If you need further help or I totally misunderstood let me know.

Thank You
Customer: replied 2 years ago.
Ok, so what I ended up doing was, adding all the groups on one sheet. So I have a lot of repeat names but in column 'F' I labeled the specific group. So column A is ID, B is First name, C is Last name, D is company, E is phone and F is group. Is there a VLookup I can use so that if the ID matches it will add the group group label next to it? maybe on Sheet2? Does that make sense?
Expert:  Chris L. replied 2 years ago.
I am not sure what you mean, what would the ID match?
"Is there a VLookup I can use so that if the ID matches it will add the group group label next to it? maybe on Sheet2?"
Customer: replied 2 years ago.
Ok, I hope this helps. I attached a link with excel sheet. What I'm hoping to do is have a list of all my contacts and know what loops they are in. I have no problems being able to delete the duplicates in the 'Results" area, but I would like to have a list of the loops they are in next to the names. I hope the sheet makes more sense of it. Thank you. http://wikisend.com/download/529182/just answers loops.xlsx
Expert:  Chris L. replied 2 years ago.
Hello, sorry for the delay I am somewhat offline and will not have time to get to this. I will opt/out of the question so you don't have to wait for me.

Thanks and good luck
Expert:  Danielle-Mod replied 2 years ago.

Hi, I’m a moderator for this topic and I wonder whether you’re still waiting for an answer. If you are, please let me know and I will do my best to find another Expert to assist you right away. If not, feel free to let me know and I will cancel this question for you. Thank you!

Customer: replied 2 years ago.
thank you and yes I'm still waiting for an answer thank you
Customer: replied 2 years ago.
Relist: Answer quality.
Expert:  John D replied 2 years ago.

Hi,

 

My name isXXXXX and I am another expert on this site

 

Is this what the first 20 rows of the Results sheet should be

 

graphic

 

Customer: replied 2 years ago.
yes that's exactly what I'm looking for John. Can you make that happen?
Expert:  John D replied 2 years ago.

Great! Yes I can write the macro to produce that report

 

Customer: replied 2 years ago.
Great, but keep mind I have have 40 loops and 2500 contacts. Is this going to be an easy macro to edit?
Expert:  John D replied 2 years ago.

Ok

 

Customer: replied 2 years ago.
How are we coming along on this?
Expert:  John D replied 2 years ago.

Ok I am almost done...

 

.

UPDATE:

 

Here you go

 

http://www.filesharesite.com/files/201202/1328754395just_answers_loops1.xlsm.html

 

To run the macro click the Go! button. When the macro finishes it will give you a "Done!" message. If you do not get that message it means macros are not allowed to run on your system. You will need to allow macros

 

Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution

 

 

John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9654
Experience: Bachelor of Science - Engineering Consultant
John D and 2 other Microsoft Office Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional