autofilter to last week by default
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 |
autofilter to last week by default
Hi,
Use a macro to apply an Advanced Filter. Tim |
All times are GMT +1. The time now is 03:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com