Hi people.

I have a lot of data importet from Access.
there is data in column A,B,C,D,E, and posting date in column F.

How can i select and copy all rows (A to E) which are dated within the past 7 days into a new worksheet using VBA?

Thanks in advance.

Best regards.