Drop down box help

[ScottBeatty]

I attached a sample spreadsheet but I was wondering if there was a code that could display a range based on an option selected in a dropdown box.

Thanks,
Scott

[FDibbins]

I would use a regular Data Validation Drop-Down.

1st, delete the box you have there.
then, Select D4 (or wherever you want to put it), under Data/data Tools, select Data Validation, select ALLOW - List
If you just have those 3 entries, type then in, seperated by comma's

Next, use this, copied across and down in D5...
=OFFSET(INDIRECT(CELL("address",INDEX($A$1:$A$17,MATCH($D$4,$A$1:$A$17,0),1))),ROW(A1)+1,COLUMN(A1)-1)

[Palmetto]

If you structured the sheet in a classic database layout you could just use autofilter. Or if you need to present the result on another sheet, use a Pivot Table and, optionally, Slicers as "pretty" selector for remotely filtering the Pivot Table from, say, a report sheet.

[ScottBeatty]

So I found that the equation worked perfectly when all of the data is presented on one sheet, however I am referencing multiple pivot tables on different sheets for the spreadsheet I am working with. Again, I attached a sample spreadsheet for clarity. Any help with the index portion of the equation would be great! Thanks!

Scott