See my SECOND answer in misc

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"MrAlMackay" wrote in message
...
Is it possible to run a macro that will do the following:
1) Copy all rows where the date is = 7 days less than today

2) Paste in a new sheet on row 4, sheet called "Completed Dates in week".

Appreciate your help on this.

Many Thanks, Al Mackay

( )