日期驱动的Excel工作簿，用于跟踪过时的任务 [英] Date-driven excel workbook, for keeping track of dated tasks

问题描述

嗨！我在lba工作，库存中有数百种独特的仪表和工具。这些仪表和工具中的每一个都必须每年进行重新校准和认证。每个截止日期都是唯一的。



如何创建一个工作簿，列出每个具有特定截止日期的数百个项目，以便当用户打开工作簿时它将告诉他今天到期了什么？



如果用户只需查询特定的截止日期或日期范围，我也会好的。

Hi! I work for a lba that has hundreds of unique gauges and tools in inventory. Each of these gauges and tools must be re calibrated and certified as accurate annually. Each due date is unique.

How do I create a workbook that lists hundreds of items that each have specific due date, so that when the user opens the workbook it will tell him what is due today?

I would also be ok if the user just needs to query for a specific due date or range of dates.

推荐答案

1。创建一个Excel表格（插入，表格）。

2.填写数据。



要获取今日列表，请过滤表格使用DueDate列。



Excel有多种方法可以过滤日期数据。





在 http://www.savetodb.com 上查看Excel的SaveToDB加载项。



它允许将数据保存在数据库中并编辑多个工作簿中的数据库数据。

它是免费的。


即使您不想使用数据库，也可以尝试加载项支持的表视图。



您可以保存多个Excel自动过滤视图只需点击一下即可应用它们。

1. Create an Excel table (Insert, Table).
2. Fill in the data.

To get the today list, filter the table using the DueDate column.

Excel has multiple ways to filter date data.


Look also at the SaveToDB add-in for Excel at http://www.savetodb.com.

It allows keeping your data in a database and editing the database data from multiple workbooks.
It's free.

Even you do not want to use a database, try table views supported by the add-in.

You may save multiple Excel auto-filter views and apply them just in a one click.

这篇关于日期驱动的Excel工作簿，用于跟踪过时的任务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！