So here's what I'm trying to do: I have one workbook with a list of company names and phone numbers. I have a second workbook with a subset list of companies that I need to call. The second list does not have phone numbers on it. There must be a way to automatically pull phone numbers from the first workbook (the complete list) and insert numbers into the subset list. Any help?
Excel can finish certain task on the basis of specific rule or relation, but cannot finish that kind of irregular distribution. Maybe, in the future it could be as that smart as we expect.