It would be a lot of work to it regularly in Excel, so I will complete the VBA to make it automatic without the table first, but you should have the table for your users, if there are any.
It will probably take me a while so it will probably be tomorrow before I can post it.
But don't worry about my time as I am retired and this is just one of my hobbies.

ps how many records does your main table currently have?