Question
Auto Populate Fields based on a Drop-down Selection
I have been tasked with creating a couple new forms. In order to simplify the work flow, I would like to use a drop-down menu in one cell, and have that selection auto-populate information that is tied to that information in a different cell.
E.G. If I select Car Engine, it auto populates V-6, V-8, HEMI in the second cell, but if I select body Style, it auto populates, SUV, Sedan, Sports Coupe, etc.
Help?
