Or is there some more to this story you're not telling us ?
- nada. The system has been running for about 10 years using monthly sheets so I am tying not to frighten the horses.
f you've got the programming skills.
- ah! Those

Err, no. That is why VBA is so good.
EDIT: Open/libreoffice macros are beginning to make a little sense, so 'steady the Buffs'. It is the re-write that is a daunting prospect, but I would have to do that for all the 'above' anyway.
.