Hi All,

I have a list of employee names working on a job, beside their names is a start date and end date.

Column A: Name
Column B: Start Date
Column C: End Date

I want to write a macro that will look at the start date and end date, and if today's date falls between those dates, I want to copy and paste the name to a separate sheet

Perhaps there is a way to use filter in my macro to achieve this result, as if it returns a blank, I don't want that blank to be copied to the new sheet.

I can upload a test workbook if that will help.

Thanks in advance