+ Reply to Thread
Results 1 to 5 of 5

Need to Look-up all Contacts at a Company and Build a List of Their Contact information

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    9

    Need to Look-up all Contacts at a Company and Build a List of Their Contact information

    I need to build a table of all contacts and their information at a certain company. Every company will have a different number of contacts. It would be ideal to expand the table rows as needed. I have attached a much shorter list of dummy data and preferred output. Thanks.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,256

    Re: Need to Look-up all Contacts at a Company and Build a List of Their Contact informatio

    Hi

    You can do this very easily by just using filters. Highlight the entire table - including headings - select "filter & Sort" on the home tab, then use the drop-down to select 1 of the shows
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-15-2012
    Location
    Beijing, China
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Need to Look-up all Contacts at a Company and Build a List of Their Contact informatio

    Hello, you can just filter in column C, when you want the data of Price is right, then filter out other unwanted data. Filter one by one with different criteria.

  4. #4
    Registered User
    Join Date
    02-27-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Need to Look-up all Contacts at a Company and Build a List of Their Contact informatio

    Thank you, but I do not want to use filters. The data is in a downloaded report and I need the data to fill tables on other tabs. I was hoping to automatically pull the information
    into my formatted tabs. I have the rest of my report automated except this piece. It is a rrecurring task for hundreds of contacts. Any other ideas.

  5. #5
    Registered User
    Join Date
    10-15-2012
    Location
    Beijing, China
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Need to Look-up all Contacts at a Company and Build a List of Their Contact informatio

    In this case, I suggest you use another free Excel helper to achieve this. It's similar to Excel but has ability for complex computing. Use esCalc to open the original data and then group by company, then you'll get the result, showing as this picture: report.png
    You can also save the result as xls, xlsx or other format. To free download it can visit this link.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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