excel用宏如何筛选日期
Over on the Contextures website, I've updated the AutoFilter Intro page, so it now covers the basics for Excel 2007 AutoFilters.
在Contextures网站上,我已经更新了AutoFilter Intro页面,因此现在它涵盖了Excel 2007 AutoFilters的基础。
However, many people are still using an older version of Excel, so I've moved the original material to the Excel 2003 AutoFilter Basics page.
但是,许多人仍在使用旧版本的Excel,因此我已将原始资料移至“ Excel 2003 AutoFilter基础”页面。
AutoFilters are easier to use in Excel 2007 and Excel 2010, and the filter and sort options are automatically added in the top row, if you format your list as an Excel Table.
如果您将列表设置为Excel Table格式,则自动筛选器在Excel 2007和Excel 2010中更易于使用,并且筛选器和排序选项会自动添加到第一行。
筛选动态日期范围 (Filter for Dynamic Date Ranges)
Among the new AutoFilter features that were introduced in Excel 2007 are dynamic date ranges. A Dynamic Date Range is one that changes automatically, as time moves forward. For example, you could select
动态日期范围是Excel 2007中引入的新自动筛选功能。 动态日期范围是随着时间的推移自动更改的范围。 例如,您可以选择
Yesterday, which will represent a different date, every day that you open the Excel file.
昨天 ,您打开Excel文件的每一天都代表不同的日期。
Unfortunately, the dynamic dates are only semi-dynamic, and they don't magically change when you open the workbook at a later date. You'll need to update the filter to see the current information.
不幸的是,动态日期只是半动态的,以后您打开工作簿时,它们不会发生神奇的变化。 您需要更新过滤器以查看当前信息。
You can update the Excel 2007 AutoFilter manually, by clicking Reapply on the Excel Ribbon. Or, you could add a bit of code to the Workbook_Open event, to reapply the filters automatically.
您可以通过在Excel功能区上单击“重新应用”来手动更新Excel 2007自动筛选。 或者,您可以向Workbook_Open事件添加一些代码,以自动重新应用过滤器。
了解有关Excel 2007自动筛选的更多信息 (Learn More About Excel 2007 AutoFilters)
If you're not familiar with the new features in Excel 2007 and Excel 2010 AutoFilters, you can learn more at Excel 2007 AutoFilter Basics. _____________
如果您不熟悉Excel 2007和Excel 2010 AutoFilters中的新功能,则可以在Excel 2007 AutoFilter Basics中了解更多信息。 ______________
翻译自: https://contexturesblog.com/archives/2010/12/08/excel-2007-autofilter-dynamic-dates/
excel用宏如何筛选日期