Hello to all,

I am a beginner at VBA and I trying to make a Workbook that will filter the raw data of one sheet based on some criteria and the copy the matching data to summary sheet. I have managed to work it out for the some of the criteria but I stacked on how to define a Date criteria and sort it out. Also, I have a field in Date Timestamp format (YYYY-MM-DD HH:MM:SSTX) which I want also to use as filtering criteria but to input it as DD-MM-YYYY.

I attach the file with an example and the VBA code.

Any help will be greatly appreciate.

Summary Date.xlsm

Thank you all.