drop down menu that will fill in some other firlds based on choice

so I have to come up with a way to allow a person to pick from a drop down list
and have it automatically fill in the cells next to it


in my example I need to be able to select a dropdown from Column A
and when you select something.. I need it to fill in the values for B-G

So if somebody selects "T56" it will fill in a group of cells next to it with the appropriate 1st/2nd/3rd/4th/5th/6th gears

Check this out, and let me know if it works:


P.S. I notice you work with car transmissions. I actually drive a Trans Am. Where are you located? PM me if necessary.