Example WB.xlsmI don't have the workbook yet. I am currently writing it and trying to include each aspect as I am going forward so I am sure that my ideas works, before going full scale :-)

However, I have attached the sheet I have for now.

A solution with the calculated result would also work! And might even be better too.