match data between two sheets based on names and auto fill

hello
I have data in sheet main for some customers so what I want match the names are existed in sheet orginal with sheet main then bring all of data for each name . so I put the result in sheet RESULT and see the sheet orginal how data was
thanks

for more explenation . it should show result in sheet orginal , but I put the result in sheet result to understand how the data were before
so it should match the names in sheet MAIN in col B with sheet ORGINAL with COL C then should brings all of data for each name .
if any thing is missed please tell me .
any help I truly appreciate .

According to your attachment a good enough readers only VBA demonstration for starters to paste to the ORGINAL worksheet module :

PHP Code: 

Sub Demo1()
    Dim F&, N$, V, R&, L&, S$
        F = 1
        UsedRange.Clear
        Application.ScreenUpdating = False
    With Sheets("MAIN").[A1].CurrentRegion
       .Columns(2).AdvancedFilter 2, , .Range("K1"), True
        N = .Range("G2").NumberFormat
        V = .Range("K1").CurrentRegion.Value2
    For R = 2 To UBound(V)
       .Range("K2").Value2 = V(R, 1)
       .AdvancedFilter 2, .Range("K1:K2"), Cells(F, 1)
        L = Cells(F, 1).End(xlDown).Row + 1
        Rows(L).Range("F1:H1").NumberFormat = N
        S = "=SUM(R[" & F + 1 - L & "]C:R[-1]C)"
        Rows(L).Range("E1:H1").HorizontalAlignment = xlCenter
        Rows(L).Range("E1:I1").Font.Size = 13
        Rows(L).Range("E1:I1").FormulaR1C1 = Array("Total", S, S, "=RC[-2]-RC[-1]", "Balance")
        F = L + 3
    Next
       .Range("K1").CurrentRegion.Clear
    End With
        Application.ScreenUpdating = True
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

thank for your trying , but unfortunately this is not what I want. see what I got after run the code

@Jindon it's very awesome ! just I ask about the formula . is there any way after calculate the values hide the formulas just show as a value . the formulas are existed in col B,C,D,H

Try add one line in bold

Please Login or Register  to view this content.

@jindon fantastic ! thanks so much for your excellent code

ABDELFATTA

Just edited the code in #5 and you will see ITEM in col.A.

@sintek well don ! but I no know if you note the code delet theses cells above for each name (NAME,DEBIT,CREDIT)
and the name should fill

Code in #5 has been updated.

@sintek please scroll the arrow you will see all the data

@jindon the highlighted cell should fill the name . I admit this my mistake
may yo see the attached file ,please?

@jindon thanks so much
it works perfectly

Originally Posted by ABDELFATTA

thank for your trying , but unfortunately this is not what I want. see what I got after run the code

I well know the result as I removed the useless ! And just for starters, so you can try to mod it …