Automatically Copy Row to another sheet with specific columns if Date is less than today's date

[hakantoz]

Hello Everyone,

I have been doing some reach in the forum trying to find the answer of my question but haven't quite found the thing that I want so following up on that.

I have two sheets, sheet1 that have multiple projects on Column A and Column L have multiple dates. What I want to happen is, if the date on Column L is less than or equal to today's date, copy that row's specific columns (A,F,G,H,K,L,R,U) in to Sheet2 starting with A3 and add a new row as data is entered. And continue doing this until all projects on sheet1 ( Column A ) is checked one by one and copied to sheet2 with respective columns. I would say, it should not exceed 200 rows overall.

Can this even be done without VBA macro script?

 

[mumps]

I think that it would be easier to understand how your data is organized if you could attach a screenshot or a link to your file as I described in Post# 7.