• 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.



Well-Known 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