Put the values based on header into last columns & matching between two sheets

[leap out]

hello
I would match data between two sheets based on matching columns B,C,D together , then should add the values from sheet RES to sheet summary under headers BUYING and SELLING . should add the values to last column (BUYING ,SELLING) ,because evrey month insert three columns BUYING,SELLING,NET. the most important BUYING,SELLING should match data between two sheets based on columns B,C,D and put the values under headers .

SUM & ADD.xlsm
	B	C	D	E	F	G	H	I	J	K	L
1	GOODS	MARK	MANFACTURE	REF	RS.N	BUYING	SELLING	NET	BUYING	SELLING	NET
2	10W40 208L	CAS	SU	RE1	RS1	200		200			200
3	10W40 208L	ENI	IT	RE1	RS1	300		300			300
4	5W30 208L	Q8	EU	RE1	RS1	120		120			120
5	10W40 208L	Q8	EU	RE1	RS1	100		100			100
6	S.AG					720	0	720	0	0	720
7	10W40 12x1L	Q8	EU	RM1	RC1	123		123			123
8	10W40 12x1L	CAS	SU	RM1	RC1	30		30			30
9	10W40 12x1L	ENI	IT	RM1	RC1	120		120			120
10	15W40 12x1L	CAS	SU	RM1	RC1	0		0			0
11	S.AG					273	0	273	0	0	273
12	5W30 12x1L	Q8	EU	RRM1	CV1	200		200			200
13	10W40 4x4L	Q8	EU	RRM1	CV1	300		300			300
14	10W40 4x4L	CAS	SU	RRM1	CV1	230		230			230
15	10W40 4x4L	ENI	IT	RRM1	CV1	123		123			123
16	5W40 4x4L	Q8	EU	RRM1	CV1	456		456			456
17	5W40 4x4L	CAS	SU	RRM1	CV1	234		234			234
18	5W40 4x4L	ENI	IT	RRM1	CV1	230		230			230
19	20W50 4x4L	Q8	EU	RRM1	CV1	123		123			123
20	20W50 4x4L	CAS	SU	RRM1	CV1	560		560			560
21	20W50 4x4L	ENI	IT	RRM1	CV1	120		120			120
22	5W30 4x4L	Q8	EU	RRM1	CV1	30		30			30
23	S.AG					2606	0	2606	0	0	2606
summary

Cell Formulas
Range	Formula
G11:L11,G6:L6	G6	=SUM(G2:G5)
I12:I22,I7:I10,I2:I5	I2	=G2-H2
L12:L22,L7:L10,L2:L5	L2	=I2+J2-K2
G23:L23	G23	=SUM(G12:G22)

SUM & ADD.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	GOODS	MARK	MANFACTURE	REF	RS.N	BUYING	SELLING
2	1	10W40 12x1L	Q8	EU	RM1	RC1	100	10
3	2	10W40 12x1L	CAS	SU	RM1	RC1	600	5
4	3	10W40 12x1L	ENI	IT	RM1	RC1	125
5	4	15W40 12x1L	CAS	SU	RM1	RC1	131
6	5	10W40 208L	CAS	SU	RE1	RS1	200	40
7	6	10W40 208L	ENI	IT	RE1	RS1	400	20
8	7	5W30 208L	Q8	EU	RE1	RS1	60	20
9	8	20W50 4x4L	Q8	EU	RRM1	CV1	10
10	9	20W50 4x4L	CAS	SU	RRM1	CV1		12
RES

result
from the first time

SUM & ADD.xlsm
	B	C	D	E	F	G	H	I	J	K	L
1	GOODS	MARK	MANFACTURE	REF	RS.N	BUYING	SELLING	NET	BUYING	SELLING	NET
2	10W40 208L	CAS	SU	RE1	RS1	200		200			200
3	10W40 208L	ENI	IT	RE1	RS1	300		300	400	20	680
4	5W30 208L	Q8	EU	RE1	RS1	120		120	60	20	160
5	10W40 208L	Q8	EU	RE1	RS1	100		100			100
6	S.AG					720	0	720	460	40	1140
7	10W40 12x1L	Q8	EU	RM1	RC1	123		123	100	10	213
8	10W40 12x1L	CAS	SU	RM1	RC1	30		30	600	5	625
9	10W40 12x1L	ENI	IT	RM1	RC1	120		120	125		245
10	15W40 12x1L	CAS	SU	RM1	RC1	0		0	131		131
11	S.AG					273	0	273	956	15	1214
12	5W30 12x1L	Q8	EU	RRM1	CV1	200		200			200
13	10W40 4x4L	Q8	EU	RRM1	CV1	300		300			300
14	10W40 4x4L	CAS	SU	RRM1	CV1	230		230			230
15	10W40 4x4L	ENI	IT	RRM1	CV1	123		123			123
16	5W40 4x4L	Q8	EU	RRM1	CV1	456		456			456
17	5W40 4x4L	CAS	SU	RRM1	CV1	234		234			234
18	5W40 4x4L	ENI	IT	RRM1	CV1	230		230			230
19	20W50 4x4L	Q8	EU	RRM1	CV1	123		123	10		133
20	20W50 4x4L	CAS	SU	RRM1	CV1	560		560		12	548
21	20W50 4x4L	ENI	IT	RRM1	CV1	120		120			120
22	5W30 4x4L	Q8	EU	RRM1	CV1	30		30			30
23	S.AG					2606	0	2606	10	12	2604
summary

Cell Formulas
Range	Formula
G11:L11,G6:L6	G6	=SUM(G2:G5)
I12:I22,I7:I10,I2:I5	I2	=G2-H2
L12:L22,L7:L10,L2:L5	L2	=I2+J2-K2
G23:L23	G23	=SUM(G12:G22)

if I add new columns

SUM & ADD.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	GOODS	MARK	MANFACTURE	REF	RS.N	BUYING	SELLING	NET	BUYING	SELLING	NET	BUYING	SELLING	NET
2	10W40 208L	CAS	SU	RE1	RS1	200		200			200			200
3	10W40 208L	ENI	IT	RE1	RS1	300		300	400	20	680	400	20	1060
4	5W30 208L	Q8	EU	RE1	RS1	120		120	60	20	160	60	20	200
5	10W40 208L	Q8	EU	RE1	RS1	100		100			100			100
6	S.AG					720	0	720	460	40	1140	460	40	1560
7	10W40 12x1L	Q8	EU	RM1	RC1	123		123	100	10	213	100	10	303
8	10W40 12x1L	CAS	SU	RM1	RC1	30		30	600	5	625	600	5	1220
9	10W40 12x1L	ENI	IT	RM1	RC1	120		120	125		245	125		370
10	15W40 12x1L	CAS	SU	RM1	RC1	0		0	131		131	131		262
11	S.AG					273	0	273	956	15	1214	956	15	2155
12	5W30 12x1L	Q8	EU	RRM1	CV1	200		200			200			200
13	10W40 4x4L	Q8	EU	RRM1	CV1	300		300			300			300
14	10W40 4x4L	CAS	SU	RRM1	CV1	230		230			230			230
15	10W40 4x4L	ENI	IT	RRM1	CV1	123		123			123			123
16	5W40 4x4L	Q8	EU	RRM1	CV1	456		456			456			456
17	5W40 4x4L	CAS	SU	RRM1	CV1	234		234			234			234
18	5W40 4x4L	ENI	IT	RRM1	CV1	230		230			230			230
19	20W50 4x4L	Q8	EU	RRM1	CV1	123		123	10		133	10		143
20	20W50 4x4L	CAS	SU	RRM1	CV1	560		560		12	548		12	536
21	20W50 4x4L	ENI	IT	RRM1	CV1	120		120			120			120
22	5W30 4x4L	Q8	EU	RRM1	CV1	30		30			30			30
23	S.AG					2606	0	2606	10	12	2604	10	12	2602
summary

Cell Formulas
Range	Formula
G11:O11,G6:O6	G6	=SUM(G2:G5)
I12:I22,I7:I10,I2:I5	I2	=G2-H2
O12:O22,O7:O10,O2:O5,L12:L22,L7:L10,L2:L5	L2	=I2+J2-K2
G23:O23	G23	=SUM(G12:G22)

 

[leap out]

any help?