Truck Fleet Management file

Before you purchase an expensive truck fleet management system, give a try to this one I created on Excel! Follow this simple tutorial and learn how to build and customize your very own file. The file includes data input for a fleet manager's daily operation - dispatch data, cost data, margins etc. You can slice information as you see fit and by building it on your own, custom fit it to your exact needs. This could be a free first step before going forward and purchasing an expensive system. Here is the VBA code used. Right click on the dashboard sheet, view code and paste this: Private Sub worksheet_change(ByVal Target As Range) Dim i As Integer Application.ScreenUpdating = False If Not Intersect(Target, Range("A2:C2")) Is Nothing Then 'Hide rows for dates without data Rows.EntireRow.Hidden = False For i = 34 To 199 If Cells(i, 2) = 0 Then Cells(i, 2).EntireRow.Hidden = True End If Next i 'Hide columns for drivers/trucks without data Columns.EntireColumn.Hidden = False For i = 19 To 53 If Cells(32, i) = 0 Then Cells(32, i).EntireColumn.Hidden = True End If Next i End If Application.Calculate Application.ScreenUpdating = True End Sub –––––––––––––––––––––––––––––– Track: Travel With Us — Vendredi [Audio Library Release] Music provided by Audio Library Plus Watch: https://youtu.be/o-rpKzt4KSY Free Download / Stream: https://alplus.io/travel-us ––––––––––––––––––––––––––––––