How combine sheet A & sheet B to result sheet C

[johnreid7477]

Hi All,

I have sheet!costumers credit and sheet!new credit. My question how to combine in sheet3!result from "sheet1!costumers credit & sheet2!new credit" if have same costumers name.




Sheet1!costumers credit

NAMA COSTUMERS	NO FAKTUR	PIUTANG (D)	PAYMENT (K)	TOTAL PIUTANG(D)
TAUFIK OPTICAL	INT 0001/IV/16	1	1	5
TAUFIK OPTICAL	INT 0010/IV/16	10	5	5
BRINGIN OPTICAL	INT 0002/IV/16	2		2
DIANA OPTICAL	INT 0003/IV/16	3		3
SEMARANG OPTICAL	INT 0004/IV/16	4		4
PEDOMAN OPTICAL	INT 0005/IV/16 H	5		5
MAYA OPTICAL	INT 0006/IV/16 S	6		6
ABC	INT 0007/IV/16 S	7		7
AAA	INT 0008/IV/16 S	8		8
AKB	INT 0009/IV/16 S	9		9

sheet2!new credit

NAMA COSTUMERS	NO FAKTUR	TOTAL PIUTANG (D)
TAUFIK OPTICAL	INT 0100/V/16	100
BRINGIN OPTICAL	INT 0101/V/16	200
DIANA OPTICAL	INT 0102/V/16	300
AAA	INT 0103/IV/16	400
ABC	INT 0104/IV/16 H	500
ABC	INT 0105/IV/16 H	600

sheet3!result

NAMA COSTUMERS	NO FAKTUR	TOTAL PIUTANG
TAUFIK OPTICAL	INT 0001/IV/16	1
TAUFIK OPTICAL	INT 0010/IV/16	5
TAUFIK OPTICAL	INT 0100/V/16	100
BRINGIN OPTICAL	INT 0002/IV/16	2
BRINGIN OPTICAL	INT 0101/V/16	200
DIANA OPTICAL	INT 0003/IV/16	3
DIANA OPTICAL	INT 0102/V/16	300
SEMARANG OPTICAL	INT 0004/IV/16	4
PEDOMAN OPTICAL	INT 0005/IV/16 H	5
MAYA OPTICAL	INT 0006/IV/16 S	6
ABC	INT 0007/IV/16 S	7
ABC	INT 0104/IV/16 H	500
ABC	INT 0105/IV/16 H	600
AAA	INT 0008/IV/16 S	8
AAA	INT 0103/IV/16	400
AKB	INT 0009/IV/16 S	9

Thanks - John

[humdingaling]

do you have the list of customers and No Faktur in results already or is that part of the question?

[johnreid7477]

do you have the list of customers and No Faktur in results already or is that part of the question?

Hi humdingaling,

Yes in fact i have list the customers in other sheet & No Faktur already.

"Sheet1!costumers credit" already + "sheet2!new credit" already = sheet3!result

I attach my example without List costumers & Invoice.


Thanks

[humdingaling]

Please Login or Register  to view this content.

i dont know how your sorting the list after you have copied over though....what logic are you using?

[jindon]

This should do as you want.

Please Login or Register  to view this content.

[johnreid7477]

Many thanks for humdingaling & Jindon.

[johnreid7477]

This should do as you want.

Please Login or Register  to view this content.

Hi Jindon,

I have one question if in "sheet2!new credit" have new "nama costumers" no list in "Sheet1!costumers credit", how to add new in " sheet3!result".

In example i'm try add 3 new "nama costumers".


Thanks - John

[jindon]

I don't understand what you are asking...

Can you just upload a file with before/after showing clear logic?

[johnreid7477]

I don't understand what you are asking...

Can you just upload a file with before/after showing clear logic?

Sorry if make confusing, i try upload new workbook

[jindon]

OK, thanks.

Please Login or Register  to view this content.