| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofilter to last week by default
Hi,
Use a macro to apply an Advanced Filter. Tim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default to a particular day of week | Excel Discussion (Misc queries) | |||
| group sales by week and week number | Excel Discussion (Misc queries) | |||
| Tie a Calendar week to a Scoped Projected Week | Excel Worksheet Functions | |||
| How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Linear Mode
