Can I have two filters?
 

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

Can I have two filters?
 

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.

--
Gary''s Student


" wrote:

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