Getting 2 excel workbooks to talk to each other RRS feed

  • Question

  • So here's what I'm trying to do:
    I'm an intern at a medium sized company. Right now they have me making phone calls. I was given two excel lists. The first list is a complete set of companies and their contact phone numbers (this list is about 5,000 lines long). The second workbook is a list of companies that I need to call (much smaller, about 50 lines long) but, this list doesn't have phone numbers. I've been switching back and forth between lists for every call. We have dozens of people making similar calls and all together we must be wasting an absurd amount of time. I'm hoping there's a way to have the smaller list of companies we need to call, extract the phone numbers from the larger list. Any help?
    Thursday, July 30, 2009 2:50 PM