As again you didn't create the thread in the appropriate VBA section (‼)I think VBA can work
I ought to apologise for that statement. I was in a rush to get onto a WebEx meeting so was not as tactful as I might have been.The introduction of tables renders the original spreadsheet concept of direct referencing unnecessary and, thankfully, obsolete.
I am not sure I understand the problem or your intended output. How far does the attached workbook come to meeting your specification?