Autofilter by Date

[RagonichaFulva]

Hello,

I wish to use VBS to autofilter a certain column, but it's a little bit confusing.

I have a date format column where I wish to filter, first by year.

I have developed this code:

Please Login or Register  to view this content.

Unfortunately, it doesn't work.

After filtering by year I need delete the resulting records and then perform a second filtering by day of 2012 (let's say, everythinf before the 25th of May for example).

I used tha macro recordar, but it displays teh following code:

Please Login or Register  to view this content.

but I don't understand how the array is used.

When filtering by day I obtain:

Please Login or Register  to view this content.

But I need this to be something dynamic. I can't write all the dates because the code is going to be used in different dates And I want to filter accordin to a date a user will give me through a date variable.

I would much appreciate your assistance.

[venkat1926]

it would have been more helpful if you had attached sample worksheet with the same configuration
see my sample sheet attached "ragonich.xls"

on this sheet run the macro which is in the vbeditor module and also repeated here for those who do not want to open the file

study the macro and modify it to suit you
the filtered data is in sheet2

Please Login or Register  to view this content.

[JosephP]

Please Login or Register  to view this content.

should filter for 2011 year only.

[RagonichaFulva]

Thank you very much for your code, I'll study it and it will certainly help me to get what I need.