VBA, selecting specific row dated past 7 days (week)

Hi fokes.

I'm relatively new to this VBA and trying to make a process at work a lot easier.

I have an Excel sheet where rows are filled by different people and column F indicates the date the data was posted.

I want to search the document with a VBA macro looking only for rows where the dates in column F are within the past 7 days.
When the rows are indicated, I want to select the data from column A in this row, and post in a different workbook.

Is this possible to do with a VBA macro and which code would i need ?

Best regards

This is one way
Open the attached workbook and run macro with {CTRL} + t
Results based on values in sheet1, appear in sheet2

Please Login or Register  to view this content.