|
As you said in the excel forum it has to be done with a vba macro.
One way would be to have variables inside the macro that would present each workhour. They would all be initialised to FALSE,
then the macro would start going through all the records/fields and put a true value when it finds an assignment to a workhour.
When all the variables are true the macro can stop and return that this period (day ..) else it returns that there are missing assignments. Checking for each type of work seperatly would make it more readable.
ZB
__________________
Sodomy non sapiens. : I'm buggered if I know
|