VBA & Advanced Autofilter

[LT]

Hello everyone.

I need some help in figuring out how to get Excel VBA to filter a
record for a specific month.

I'm trying to code a macro that will generate a list of all employees
born in a certain month and Excel keeps adding 2007 to my filter.
I've tried with just dd/mm, using the Month(1) function and a bunch of
other little things.

Any ideas what I'm doing (or not doing) wrong?

Thanks in advance!

(My example code)

Worksheets("CustomReports").Range("B1").Value = "Date of Birth"
Worksheets("CustomReports").Range("B2").Value = "January"

 

[Ron de Bruin]

Hi LT

Example

A6 = header
A7:A100 dates

leave A1 empty
in A2 enter this formula =MONTH(A6)=1

Use as criteria A1:A2

You can rerord a macro when you do this

I also have a add-in that you can use if you want
http://www.rondebruin.nl/easyfilter.htm

 

[Ron de Bruin]

I see I have a typo

in A2 enter this formula =MONTH(A6)=1

Must be

=MONTH(A7)=1

The first cell with a date (A6 = the header)

 

[LT]

I see I have a typo


Must be

=MONTH(A7)=1

The first cell with a date (A6 = the header)

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm










- Show quoted text -

Ron, thank you very much for your help and input. Also I will be
trying your app. Cool stuff! Thanks!
-LT