I am still dubious.
How are you doing it manually at the moment? Have you attempted a VBA solution?
As i said it is a very bespoke request, if i was you, i would get it working for 1 row then start adding in each year category as a variable within a loop.
Unfortunately 'VBA Codes' that are generic don’t really exist
|