Need Help to copy with criteria

[flik_17]

Dear All.
i need a help to copy data with criteria and sum it per code in blank sheet namely sheet2. i'll apreciate your help. thx very much


Regards. flik

[nathansav]

Use a pivot table

[flik_17]

thx for suggestion

ill try your suggestion, but it consume time to copy paste manually.
so i decide to use macro

[nathansav]

You dont need to copy anything, just use a pivot table.

[flik_17]

pardon me sir. i know what you mean.
then is pivot data can be arranged like my template before?

[nathansav]

yup! Example below

Row Labels Alvin Bram Delta Gohto Graham Henry Ilham Intan Kate Lawrence Grand Total
A-100 850000 850000
B-100 726000 726000
D-100 360000 360000
G-100 250000 250000
G-150 200000 200000
H-100 968000 968000
I-100 400000 400000
I-150 7956000 7956000
K-100 2525000 2525000
L-100 520000 520000
Grand Total 850000 726000 360000 200000 250000 968000 400000 7956000 2525000 520000 14755000

[flik_17]

thx sir it works!!

i have no idea about this before