I have an excel spreadsheet that uses drop down lists to select specific items, I would like to it to autofill certain cells with set figured when a particular item is selected from the drop down list.
EG. A spreadsheet that has a list of cars and when you selct a certain make it autofills cells for manufacturer, year, body type etc.
Has anyone got any ideas on how to do this.
Thanks in advance