autofilter to last week by default

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of dates from today through 2009 in column A. In column B
there is a formula to find the Sunday date of each of those weeks represented
in column A.

I am duplicating this worksheet 15 times in the workbook. Rather than
manually change the autofilter in each worksheet I would like to have the
autofilter default to the previous Sunday date based upon Today's date. Can
I do this?

Dan
 
Back
Top