I posted something similar, but wasn't at all clear. This is what i am
trying to do.

I want to place a drop-down select box on Sheet 3 with values 1-12,
representing months of the year. I want the user to be able to select a
month value from the drop-down select box. Once the value is selected, i
want Excel to search column B on Sheet 1, looking for all date values
matching the month selected by the user. I then want Excel to copy the
identified rows in Sheet 1, including column headers, to Sheet 2, replacing
anything that was there previously.

Can anyone help me out with this?
--
Carlee