Hi, I was wondering if someone could help me...

I have rows in one sheet (call that the mastersheet) where one of the
columns is "date file received". I want all rows where that date is
less than 7 days copied over to another worksheet (call that the
reportsheet). That's it.

To complicate matters, on the reportsheet, below the result from the
above, I want another set of rows from the mastersheet pulled over
based on the column "Date file Actioned" where the date is within the
last 7 days.

Anyone??? Thanks,

Rob

I dont know VB at all. Any way to do this with just formulas?? TKS.