Hi,
I need to discuss with you about the environment to run the Macro
In order for this to work daily, I will need to config the Task Scheduler of Windows (because we cannot assume that the PC and the Excel is open all the time), in that way the Task Scheduler will call the Excel file and the macro at least once per day.
Another problem is that when the macro is running, you should not modify the data in the Excel file. So we will need to make sure that you or your staff need to remember that macro running time.
Also in your requirement you said "still work when children are removed", do you mean that if you remove one or more children, the macro still working with the rest?
And about last part of your requirement, I thought the Immunization information should not have anything to do with the macro?
Regards,