In this version, Badge's for report are queried from Assessment sheet, and the report table is expanding/shrinking automatically. The query uses a fixed named range as source, and is created from menu Data > From other Sources > From Microsoft Query with Excel Files* as data source.
To eliminate the need of editing the query, I added an Open event, which adjusts query automatically, whenever workbook is moved or renamed. Having an Open event in workbook was the reason for change of workbook format to xlsm. To get the query to work, the workbook must be saved somewhere.
The query is refreshed automatically whenever the workbook is opened. During session you have to refresh it manually, when the need arises.
|