Auto Populate sheet using multiple drop down lists

[makel]

Hi,
I am looking to auto populate a spread sheet using multiple drop down lists, 4 to be exact. It is a dimensional drawing of a tool, where the dimensions will change when a different size and weight and material is selected from the drop down list.
Please let me know if you can help me out.

Thanks,
- Matt

 

[pbornemeier]

You have to provide more details before anyone can decide to help.
You may want to use google to search this site for cascading drop down boxes

 

[Jake Blackmore]

What you need is an excel table (via Insert) and on each column you need to set up data validation from the list of options you want available.