Although I prefer using Word for reports, I think in this case I would probably try to do it in Excel. I should add that this would not be a simple thing and I would need to do some learning myself. I am currently working a Udemy course on this by Alvin Jarvis to learn how to do this. It is Excel Essentials - Level 3 - vba.


You might want to post in the Excel programming forum instead of the Word forum and see if you get any help there. If you do, please provide a link back to this thread in your post there and post a link to the new thread here.