I was asking whether "Register" was a Excel keyword / concept or your term.

Thank you for your responses. I certain I could handle this in MySQL, reasonably confident through Excel VBA, but am not familiar with the Excel commands / keywords you reference.



Thanks again

No, it isn't!

Attached is a simple example what I did mean (based on your yesterday post, but also expanded a little).

On sheet DataEntryTable, the column Warnings gives warning message, when selected month is outside of time frame for selected project. Columns startMonth and EndMonth are helper columns, and you can hide them.

I didn't design any reports, but on Projects sheet I added columns where various totals for projects are calculated (column headers are colored green)

Attached Files

ProjectManagingExample.xlsx (23.2 KB, 9 views)