Date-driven excel workbook, for keeping track of dated tasks

Question

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 27-Apr-14 14:20pm

Member 10779092

Add a Solution

Comments

[no name] 27-Apr-14 21:09pm

http://www.google.com/search?q=vba+for+excel

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Sergey Vaselenko · Answer 1 · 2014-04-27T21:35:00

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.