In added example, all work registration is made in single table. You can get worktable for every consultant in given month from added report. Another report displays monthly summary report. Rest of tables are various registries which are needed to get various Data Validation Lists to work.


You can hide some register tables. And you can hide some calculated columns (colored brown) in data entry table and in consultant monthly report.


In summary monthly report, I couldn't understand from where some data was got, and what you tried to do. So the report is not finished.

Attached Files

WorkbookExample.xlsx (63.6 KB, 11 views)