advanced filter month

[methody]

Hello there
I have a long list of events with the date (dd/mm/yyyy) in column A and further details for each acrooss the row. I basically want to be able to filter the events by month. And I want to activate it by changing a cell with the 12 months in them. I know how to put a list of months into a cell using data validation and I know that it is probably some form of advanced filter but I'm not sure what formula to use.
If at all possible I don't want to have to enter another column with a formula in.

I'd appeciate any help

 

[Aladin Akyurek]

What is the range the data (including the labels) occupies and the sheet which houses that range?

What are the labels?

The date questions as almost always forget the year issue. Does the date range consist of single year?

What is the destination - the same sheet or a different sheet? If different, what is the name of that sheet?

 

[methody]

the data range is A4:D100 with the labels (date, title,time, contact no.) in row 4. The dates in question will only be in one calendar year so there will be only one relevant month. The name of the sheets is "events" and there is no destination sheet. I just want to filter the rows on the actual sheet.

hope this helps

 

[Aladin Akyurek]

the data range is A4:D100 with the labels (date, title,time, contact no.) in row 4. The dates in question will only be in one calendar year so there will be only one relevant month. The name of the sheets is "events" and there is no destination sheet. I just want to filter the rows on the actual sheet.

hope this helps

Data validate F1 with Allow set to: Whole Number, Data to: Between, Minimum to: 1, and Maximum to: 12. Then make a choice from F2.

Leave F2 empty.

In F3 enter:

=MONTH(A5)=$F$1

F2:F3 is called Criteria (range).

Fire up Data|Filter|Advanced Filter.
Set Action to: Copy to another location.
Set List range to: $A$4:$D$100.
Set Criteria range to: $F$2:$F$3.
Set Copy to to: $F$4
Leave the Unique records only option unchecked.
Click OK.

You can, if so desired, run the Macro recorder in order to create a macro so that you can repeat the above steps automatically with any new choice from F1.

 

[methody]

thanks
I,m not quite sure about

"Then make a choice from F2.

Leave F2 empty. "

Could you explain

 

[Aladin Akyurek]

thanks
I,m not quite sure about

"Then make a choice from F2.

Leave F2 empty. "

Could you explain

The first sentence has it wrong: It should be F1, the cell I proposed to data validate.

 

[methody]

thanks very much