You can, use VBA to automatize your file, and follow your readers step by step with highlight incorrect places or shutdown color from empty spaces.
Also you can have connection between fields based on comboboxes or listviews. I don't know what your experience is on this topic.
If you start then start from a book with VBA chapter. That is a good way to understand how that works.
That you should to know that files with code you should "save with code". That is not trivial because you can lost your efforts.
And our readers Should to know who is a creator, because file with code can be block because security issue.
If you start and you have a problem with a specific case, show what exactly.
Regards.