Can I have two filters?

[czbacnik]

I have a worsheet that has employees names and dates corresponding to
their sick and vacation hours (sick and vacation hours are each on
their own seperate worksheet). I want to be able and filter employee
name and date to show what these hours are. Anyone have any ideas how
to do this?

Please HELP!

Thanks,

Carla

 

[Guest]

AutoFilter can help you:


If you have a header cell on top of each column, select one of them and
pull-down:
Data > Filter > Autofilter

Each column will then get its own pull-down. You can set each filter
individually.