+ Reply to Thread
Results 1 to 6 of 6

Need to quantify names of agents assigned a specific company

  1. #1
    Forum Contributor
    Join Date
    05-22-2012
    Location
    Boise, Idaho
    MS-Off Ver
    Office 365
    Posts
    156

    Need to quantify names of agents assigned a specific company

    I have a document with horizontal lines of data that contain agent assignments and priorities for each assignment. What I would like to do is be able to view in a chart or pivot or other, the agents assigned to particular companies and the subsequent priority.

    The goal is to be able to quickly select the company from a pivot or dropdown or other and identify which agents are assigned to that specific company and their priority. The full data I'm working with is over 240 columns and about 1500 lines of data
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need to quantify names of agents assigned a specific company

    Try this code on a dummy of your data.

    Please Login or Register  to view this content.
    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    05-22-2012
    Location
    Boise, Idaho
    MS-Off Ver
    Office 365
    Posts
    156

    Re: Need to quantify names of agents assigned a specific company

    Oeldere can you give more guidance on how I go about using this code?

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need to quantify names of agents assigned a specific company

    Open my offered excel file.

    Alt + F11 opens the VBA editor.

    I added module 1 to add the code.

    You will see the module at your left hand side and the VBA code on the right hand side.


    You can run the code:

    view => macro => show macro => CONVERTROWSTOCOL_Oeldere_revisted_with_step() => run


    It will take all the data where in row 1 is a header.

    I tested it on the data till column AD (see my example).


    It will take a while for the code to get all the data, so I suggest you test it on the file I offered you.

    You can remove the sheet Output and after that run the code (see the text above).


    If you are satisfied with the result you can implement it in your original file.

    Probably there is code to improve the speed of the code, but I can't help you with that improvement (enough).


    After that I made a pivot table of the data.


    If you have (other) questions, just ask.

    Please reply with your findings.

  5. #5
    Forum Contributor
    Join Date
    05-22-2012
    Location
    Boise, Idaho
    MS-Off Ver
    Office 365
    Posts
    156

    Re: Need to quantify names of agents assigned a specific company

    Oeldere how did you create the table on the output tab?

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need to quantify names of agents assigned a specific company

    With the macro in #2.

    See #4 how to use this macro.

+ 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. Replies: 4
    Last Post: 08-13-2019, 03:11 PM
  2. [SOLVED] Get Company names based on Product names
    By rajeshn_in in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-27-2018, 12:53 PM
  3. [SOLVED] Best price/Best company names
    By Lugashz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-08-2017, 08:33 AM
  4. Delete specific suffixes from a list of company names
    By bsmizzle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-19-2014, 08:09 AM
  5. Need help to display company names
    By shaikfazil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2012, 01:24 PM
  6. counting company names
    By jspinx in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-03-2012, 11:43 AM
  7. separating company names and addresses
    By drquietus in forum Excel General
    Replies: 1
    Last Post: 06-06-2010, 04:26 AM

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