I added edited RawData.xlsm file, where ODBC query is used to consolidate your data.
The format *.xlsm is used, as I added an Open event which corrects query parameters on open automatically, whenever the file name or location is changed. Without this this script allowed to run, you have to edit the query datasource manually every time you relocate or rename the file.
In your original table, I removed a couple of spaces from column names.
As source table for query I defined a non-dynamic named range nData. Currently it has 20000 rows - when your table has more rows, then edit nData.
Along with sum of Unit's I calculated also the number of deliveries and min of FromDate and max of ToDate.
|