Drop Down menus

[CAHILL42]

Can anyone tell me how to create a drop down menu that will sort?

I have inherited a data base that includes everyone in my organization.

There are collums with theire names etc, then a column with their shift i.e. DAYS SWINGS or MIDS....

I need to be able to click on the arrow in the drop down menu and have it show only who is on swings etc...

Can any one help? I know this is vague... thanks!

 

[north19701]

Select your range then on the menu - Data - Autofilter.

drop down menus will appear and you can select certain shifts.

 

[boxsterman]

Click on the header row.... select data, filter, autofilter and voila.

 

[golf4]

Hi -

Have you thought about using the Auto-Filter, filtering the columns? This may give you the effect you're looking for.

HTH,

Golf

 

[golf4]

OOOOOPS!!!

Well, third time is a charm.........

 

[CAHILL42]

Wow... that was REALLY easy.... thanks you guys!