• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Summary of data


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.



Active Member
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