Dear all,

I have created a database (data sheet) and I would like to copy to my other sheet "report" all the cells in column C which are greater than my limit in cell C2 and the corresponding time of column B (with no blank cells). Anyone has an idea on how to build the macro for it?

I have already tried all that I knew without macro, using if, vlookup or match but it seems to not be working well... If I understand the posts on the forum, a small macro would be the best but as it's my first steps, I have failed so far. I would need something like IF( cell> limit, copy cell to report, go to next row until ligne 150)

data.xls