The requirements in this thread have escalated somewhat such that I think VBA is required: https://www.excelforum.com/excel-pro...dashboard.html

Could a clever coder please take a look?