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
––––––––––––––––––––––––––––––

Видео Truck Fleet Management file канала Excel Highway