Two parts to this:
1. a simple and easy to use design of a database layout.
2. designing a macro to archive and sort the items in the database
I'd like to hire someone to design an excel database that will track issues for a construction project. The basic design should be simple.
Each part of the project will have its own tab (acquisition, design, construction, entitlement, financing) plus one tab for a dashboard.
In each tab, there will be a classic database layout. One line per item and each item having the following details across the top line: Subcategory (drop down menu), Item, Action (drop down menu), description (allowing for a long narrative) , Responsible party, Critical Date, Resolution (a long narrative) and Status (drop down menu).
I hope that a macro can be written which archives all resolved items in an archive tab, and adds, which tab it was taken from.
- macros written, so that each column heading can be sorted with a button.
- each line...