Hello.
I can help you with your requiremente with any problem. I haven't got any projects here but I have a lot of experience on programming with VBA. Anything you do on Excel can be automated, format included.
I will be glad to assist you, I hope you give me a chance.
Best.