Sorting Drop Down Boxes

[roadwarrior]

Hi!
I am hoping someone can help me. I have small sized set of data ( 5 columns, 250 rows) that i would like to be able to sort with drop down
boxes--with some level of hierachy. (ex drop down selection should
only show relevent rows) I would like drop downs menus on each of the five header columns...which sort across all of the rows..not just the row for that column.. can someone help?
thx.

 

[yytsunamiyy]

Sounds to me like autofilter will do exactly what you are looking for. Have a look at it and post back with a better description of what you are trying to achieve if this isn't the solution.

EDIT: Welcome to the board!

 

[roadwarrior]

It worked! Thank you so much!
(that was way too easy)

Take care,
Road warrior