Sort data within past week

Hi,

The simplest way would be to Autofilter the data and then copy the filtered rows and paste them to a second sheet.
If you really want to do this with a macro then switch on the macro recorder, perform the Autofilter and the Copy Paste.

If you've picked the 'Filter last week' option then the macro probably doesn't need any edititing, otherwise it may do to create variables for the week definition.

Upload the workbook if you're still struggling when you've done that.