title: Excel When Drop down box selected auto fill other boxes
body: <p>I have an excel spreadsheet that has drop down comboboxes on sheet 1. I am trying to find out how to autofill the 5 boxes to the left of the combobox with content from sheet 2 when a specific drop down is selected. </p>