I want to make a workbook with two spreadsheets. One is a list of customer data called customers. the other one is a draft of a doc. So I want to place a combo box in the doc spreadsheet where one should be able to choose one of the customers, once you do that the other cells in doc spreadsheet are automatically filled with the rest of the info of that customer from the customer spreadsheet. How can I accomplish this?