VBA to filter data after a date

[jonathan.haynes]

Hello,

I'm looking for a VBA to filter my data after a date. Presume this is something very small i've missed.

This is what I currently have..

Please Login or Register  to view this content.

The date in cell J1 is 02/08/2013 (EU formatting).

Any help would be great.

Thanks

[smartbuyer]

Try this:

Please Login or Register  to view this content.

[jonathan.haynes]

Hi,

Yes this is good, however 2nd august date needs to refer to cell J1 as it changes everyweek. Is there a way of doing this?

Thanks

[jonathan.haynes]

Anyone!? Surely can't be that hard unless you're me

[AB33]

Please Login or Register  to view this content.

[jonathan.haynes]

Please Login or Register  to view this content.

This doesn't work - it is simply running a macro and putting me back at step 1?

Thanks

[AB33]

Please attach a sample.

[jonathan.haynes]

Thanks AB, please see attached.

Example workbook v74.xlsm

[AB33]

Okay,
You criterion is not on the same sheet. It is in different sheet.
What do you want to do once you filter the data?

[jonathan.haynes]

My apologies.

All I want to do is filter the data so that's all

Thanks

[AB33]

Jonathan,
Dates have been nightmare in excel. I have played around with different code and the problem is the date in J1 or P4. I have hard coded that is

Please Login or Register  to view this content.

It works, but as soon as I change the criterion to a range, it comes with some funny result. I have tried formatting and changing the data in to date format, but to no avail. When I formatted the P4 or J1 in to number format, it works.
I do not know why 41488.00 works, but (02-aug-13) does not work.

This code works with the date is formatted as number.

Please Login or Register  to view this content.

[jonathan.haynes]

OK, great.

So i'm trying to put this into the example workbook and it is not working. All it is doing is removing the filters from row 2.

Please could you upload your example workbook so I can see?

Many thanks.

[jonathan.haynes]

I've come up with a solution for this - no date is ever going to be past 2099 so it would be easier to filter between two dates

Cell S1 contains date 01/01/2099.

Please Login or Register  to view this content.

Thanks for all your help anyways

Cheers