Click here to Skip to main content
14,838,044 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.

Posted
Comments
[no name] 27-Apr-14 21:09pm
   
http://www.google.com/search?q=vba+for+excel

1 solution

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.
   
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900