Not a VBA coder, but like yourself if i find something similar and can tweak a couple of things to make it work or else just record a macro on something i want to do and grab the code from there.
I’ve got an idea on how to make it work and would be macro based. Is that data paste within Excel? i see grid lines and i would say it would be. If so i’ll make a mock up test like that and see if it works.