My first post after referencing the forums here many, many times. So thanks to everyone for all the solutions I've found in the past! I apologize if my new topic has already been answered, but I can't seem to find it.

I have a workbook with two sheets, "data" and "results". On the data sheet, columns are A: start date, B: end date, C: name, D: product. The data is replaced each day and typically there are 450 rows. About 10 rows per day are new, i.e., have a start date (A) with the same date as today.

On the results sheet, I would like to display ONLY the data from the rows which have a start date of today, in essence producing a list of about 10 each time the new data is dumped.

I know I can just sort the data and look at the top rows, but I'll need to apply this same function to a much more complicated workbook where doing that is not an option, so I need to find the proper function - if it can be done.

Thanks in advance!