I consider myself an intermediate to advanced excel user, however I\'m struggling with something. I\'ve always wanted to create a form for sales purposes. In this workbook, there would be many worksheets with product PN\'s, descriptions, and costs. On the main form, when someone selects a manufacturer name from a drop-down box in A1, it automatically allows you to select a PN from the matching vendor worksheet in A2. Once the PN is selected, it automatically pulls up the description and cost and puts in their corresponding cells. Make sense? Any ideas on how to do this?