When to Use the Report Merging Macro
The macro allows you to combine two or more reports exported from Avrios into a single file for easier analysis.
For example, you can merge a TCO report (Total Cost of Ownership) with a Vehicle or Driver Dashboard to get a complete view of fuel costs, mileage, or overall expenses per vehicle.
To make this work, both reports must contain one identical column, such as License Plate or Avrios ID, which the macro uses to match the data.
Requirements
Both reports must be exported from Avrios.
Both files must contain at least one identical column header (e.g. License Plate, Avrios ID, Driver Name).
You have the macro file “Macro_Reports_Joining.xlsm” available.
Step-by-Step Guide
Export the Reports
Export the desired reports from Avrios (e.g. TCO report and Vehicle Dashboard) and save them locally on your computer.
Open the Macro File
Open “Macro_Reports_Joining.xlsm” in Excel and enable macros when prompted.
Import Report 1
In the yellow field, enter the name of the column that appears in both reports (e.g. License Plate).
Click “Import Report 1” and select the corresponding file.
Import Report 2
Repeat the process for the second report.
Use the same column name in the yellow field.
Click “Import Report 2”.
Merge the Reports
Click “Merge!”.
The macro will automatically generate a new Excel file combining both reports.
Result
Once completed, you’ll receive a new Excel file that merges the data from both reports.
You can manually remove or adjust unnecessary columns as needed.
Tips
Ensure that column headers match exactly (no extra spaces or different spellings).
The macro works only with .xlsx files.
Save the final merged report locally or to your company’s shared drive for further analysis.
Example:
You want to combine the Total Vehicle Costs (TCO) from the cost report with the License Plates from the vehicle report.
Since both contain the column License Plate, the macro will automatically match and merge the data into one file.