Summary of data

[Shabbo]

Dear Sir,
In Summary Sheet I wanted to make summary of data entry sheet as per summary format.
Can you please how it can be done?
In Data Sheet I have date and Vehicle number I wanted to find HireSlipno from Data entry sheet, but it’s not working because vehicle number format is different.
Please advise.

 

[AlanSidman]

Run this VBA code on the Data Sheet to reformat the information in Column C

Option Explicit

Sub Reformat()
    Dim i As Long, lr As Long
    lr = Range("C" & Rows.Count).End(xlUp).Row
    Application.ScreenUpdating = False
    For i = 3 To lr
        Range("C" & i) = Right(Range("C" & i), 4) & Left(Range("C" & i), 5) & Mid(Range("C" & i), 7, 2)
    Next i
    Application.ScreenUpdating = True
    MsgBox "completed"
End Sub

After running this code, you can then apply either vlookup or index/match to do your lookups