copy data based on date value

[xpost][/xpost]

https://www.excelforum.com/exc…py-data-to-new-sheet.html

https://www.mrexcel.com/board/threads/date-range.1194088/

Hi all hope you could help me with this matter

I have a workbook that contain multiple sheets

1 DATA ENTRY where all data is fully entered

2 EMPLOYEE DATA is where i display the entered data based on the salseman name selected in the A7 cell

3 REPORT

4 DAILY TASKS which i want to the cells in colum J & S in the EMPLOYEE DATA to be copied to this sheet based on the date value in column S

which mean all the dates that are passed due or approaching due will be copied to the DAILY TASKS sheet with the cells related to them in the column J

I hope i made it clear so you can understand the request i hopefully you could help with

Dear Roy

sorry for the previous attachments this is a small sample of my worksheet

Thak you in advance