I created a form with multiple drop-down list boxes which pulls data from an .xml file i generated from Excel. I would like to only change on drop-down list and then the rest of the fields will populate according to the row that the data came from. Example, drop-down list A is populated from data that is in cell B1. I want the next drop-down box to auto populate with data in B2, and the next drop-down to auto populate with B3, etc.
Is this possible?
Thanks in advance for your help.