Display different table based on drop down selection

[hkaplan2]

I would like to display a different product price list on a worksheet based on the users selection from a drop down box. For instance, the user selects "Auto parts" and the table displays only Auto parts. If they select "Boat parts" then the table changes to display only boat parts. I can either set up each table as a separate range to be displayed, or have a field in the table that designates which category each item belongs to, or any other way to make this work. Thank you in advance.

 

[Brian from Maui]

See,

http://www.mrexcel.com/board2/viewtopic.php?p=154#154

 

[tusharm]

For a solution that uses data in relational tables see
Cascading queries
http://www.tushar-mehta.com/excel/newsgroups/cascading_dropdowns/index.html