Macro to copy data where date is 60 days or less than the current date

[howard]

I would like to copy Cols J to L onsheet1 where the dates in Col L is 60 days or less than the current data to sheet2

for e.g. if the current date is 01/03/2018 (dd/mm/yyyy) then dates 01/12/2017 and earlier to be copied to sheet2

It would be appreciated if someone could provide me with code to do this

Book1
	J	K	L
1	Reference	code no.	Date Processed
2	KDGE396	6441	06/10/2017 00:00
3	KDGE396	6441	06/10/2017 00:00
4	C5HB519	7607	16/10/2017 00:00
5	6H53116	7743	17/10/2017 00:00
6	2NHG063	7820	18/10/2017 00:00
7	2NHG050	7839	18/10/2017 00:00
8	2NHC147	8705	28/02/2018 00:00
9	2NHC147	8712	24/10/2017 00:00
10	2NHC147	8713	24/10/2017 00:00
11	KDHJ228	2105	20/11/2017 00:00
12	2PHK235	2804	24/11/2017 00:00
13	KDHP414	3197	28/02/2018 00:00
14	2PHC161	3675	30/11/2017 00:00
15	WJHC145	3699	30/11/2017 00:00
16	WJHC145	3699	30/11/2017 00:00
17	WJHA891	3723	28/02/2018 00:00
18	F5H3159	3747	30/11/2017 00:00
19	WJHA014	3856	30/11/2017 00:00
Sheet1

 

[VBA Geek]

you can do this very easy using advanced filter:
http://www.contextures.com/exceladvancedfiltervba.html

by using as condition:

Excel 2010
	E
1	Date Processed
2	>43099
Sheet8

Cell Formulas
Range	Formula
E2	=">" & TODAY()-61

 

[howard]

Thanks for the help, much appreciated