DATE RANGE

[fady77]

Hi all again I have this data worksheet that contains "DATA ENTRY" where all the data are entered on daily basics and the "EMPLOYEE DATA" where we display all the entered data based on a cell value (salsseman) A7
i would like to create a report list that provide all the PO # (column J) based on the date in (columnS) the report list will only give the data which the dates has passed the date range
The column S has a conditional formating that gives the date range that are between today and today+2 in yellow and the dates that are =< than today in red
i hope i explain my points so you could help me
I tried to use the if and match range but i couldn't succeed
please find attached the pictures for more details
Thank you

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: copy data to new sheet
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[fady77]

Hi these are the links for the same question i hope it is not a problem

copy data to new sheet

Hi all hope you could help me with this matter I have a workbook that contain 2 sheets 1 DATA ENTRY where all data is fully entered 2 DAILY TASKS which i want to the cells in colum G & L in the EMPLOYEE DATA to be copied to this sheet based on the date value in column L which mean...

www.excelforum.com

https://www.ozgrid.com/forum/index.p...88#post1254888

 

[Peter_SSs]

Thanks for the extra cross-post link.