VBA to filter data by date

Hello!

I have a sheet that contains details of club members with their join dates (col E) and date of their last visit (col B).

I need some code that will filter out members that haven't visited in at least 2 months (or 61 days) from today's date - but also joined before then (to avoid including new joiners who don't haven't even visited for the first time yet).

The data range is indefinite (as member numbers change all the time) so the code will need to find the last row.

I have some existing code for another project that kind of filters by date so this could be used as a model but it's not specific to this purpose...

Please Login or Register  to view this content.

Please can someone help me out?

Thank you!

Thanks for your reply! Unfortunately I do need to do it with vba. Basically our computer system generates this report as a .csv file and then I want to filter the data and copy it over to another workbook. So the user will generate the report, attach the file with an 'import data' button on the workbook and it will only copy over the relevant data.

I have attached the .csv file and the second workbook so you can get the idea.

Thanks!