autofilter to last week by default

[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

 

[Guest]

Hi,

Use a macro to apply an Advanced Filter.

Tim