John

You might find that an advanced filter is what you need.
See Deborah Dalgliesh's site Contextures.com

The criterion to filter November's data would be
=MONTH(A11)=11 if the dates are in column 1 and the list
starts at row 11.

You can use an inputBox for the manager to to insert the
month number with somthing like

x = Inputbox("Enter the number of the month")
range("a2")= "=MONTH(A11)=x"

Deborah shows how to extract certain fields to another
place

Peter Atherton
-----Original Message-----
Hi, I have a workbook that is used throughout the
company.
My boss wants to report on certain fields based on month.
The only problem is that all cells with a date in them
are
all mm/dd/yy. I want to present my boss with a userform
that will ask her what month she wants, then go to any
worksheet and get the information she needs.

How can I query the date cells with only a 2 digit month?

Thanks
.