I'm attempting to make a list that auto populates based on a selected name. In other words, I have a large data base of customers in one workbook(each of the customer data has a marketing rep attached to it is an adjacent cell); I'm making another file that has a list of marketers. I'm trying to make the the marketer file populate based on the name of the marketer from a drop down with the data source. Any suggestions?