Data entry for tracking items
I have an automatically populated table that shows any outstanding item, this includes IDs, date info etc. This will be overwritten daily as items are added/removed by our internal system.
I'd like to do the following: Add additional columns that calculate if items a re past due and owners by looking up the ID with another pre-populated table. Manually add information that shows if the item can be ignored in the future (if the system doesn't remove it for some reason)
Ideally, I'd end up with one table showing the outstanding items where the user can scroll through these and add info one by one.