Hi,

How can i tell a macro to look in column D, and select the whole row if the
date in column D is a date from the current week? This report is run every
Friday's so i only want the dates from the last 5 days... and then copy and
paste all that info (including all columns (column headers aswell) with the
relevant rows selected) )into another new blank sheet in the same workbook
and call it 'DATE SORTED'.

Thanks a lot.