match column across sheets and summing values into last columns

[leap out]

Hi experts,



I would match data between acroos sheets based on matching columns B then should add & summing the values to sheet summary under headers BUYING and SELLING . should add the values to last columns (BUYING ,SELLING) ,because evrey month insert three columns BUYING,SELLING,NET. the most important BUYING,SELLING should match data across sheets based on columns B and put the values under headers (BUYING ,SELLING).

as in picture 1 , the values which showing in column H brings from the other file . it's openning balances , so it 's not relating of the others sheets .

SUM & ADD1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	CLASSIFICATION	CODE	GOODS	MARK	MANFACTURE	REF	RS.N	BUYING	SELLING	NET	BUYING	SELLING	NET	BUYING	SELLING	NET
2	OIL-AS2	OIL-100	10W40 208L	CAS	SU	RE1	RS1	200		200			200			200
3		OIL-101	10W40 208L	ENI	IT	RE1	RS1	300		300			300			300
4		OIL-102	5W30 208L	Q8	EU	RE1	RS1	120		120			120			120
5		OIL-103	10W40 208L	Q8	EU	RE1	RS1	100		100			100			100
6		S.AG						720	0	720	0	0	720	0	0	720
7	OIL-AS2	OIL-104	10W40 12x1L	Q8	EU	RM1	RC1	123		123			123			123
8		OIL-105	10W40 12x1L	CAS	SU	RM1	RC1	30		30			30			30
9		OIL-106	10W40 12x1L	ENI	IT	RM1	RC1	120		120			120			120
10		OIL-107	15W40 12x1L	CAS	SU	RM1	RC1	0		0			0			0
11		S.AG						273	0	273	0	0	273	0	0	273
12	MS-OIL1	OIL-108	5W30 12x1L	Q8	EU	RRM1	CV1	200		200			200			200
13		OIL-109	10W40 4x4L	Q8	EU	RRM1	CV1	300		300			300			300
14		OIL-110	10W40 4x4L	CAS	SU	RRM1	CV1	230		230			230			230
15		OIL-111	10W40 4x4L	ENI	IT	RRM1	CV1	123		123			123			123
16		OIL-112	5W40 4x4L	Q8	EU	RRM1	CV1	456		456			456			456
17		OIL-113	5W40 4x4L	CAS	SU	RRM1	CV1	234		234			234			234
18		OIL-114	5W40 4x4L	ENI	IT	RRM1	CV1	230		230			230			230
19		OIL-115	20W50 4x4L	Q8	EU	RRM1	CV1	123		123			123			123
20		OIL-116	20W50 4x4L	CAS	SU	RRM1	CV1	560		560			560			560
21		OIL-117	20W50 4x4L	ENI	IT	RRM1	CV1	120		120			120			120
22		OIL-118	5W30 4x4L	Q8	EU	RRM1	CV1	30		30			30			30
23		S.AG						2606	0	2606	0	0	2606	0	0	2606
summary

Cell Formulas
Range	Formula
H11:P11,H6:P6	H6	=SUM(H2:H5)
J12:J22,J7:J10,J2:J5	J2	=H2-I2
P12:P22,P7:P10,P2:P5,M12:M22,M7:M10,M2:M5	M2	=J2+K2-L2
H23:P23	H23	=SUM(H12:H22)

SUM & ADD1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	CLASSIFICATION	CODE	GOODS	MARK	MANFACTURE	REF	RS.N	BUYING	SELLING	NET	BUYING	SELLING	NET	BUYING	SELLING	NET
2	OIL-AS2	OIL-100	10W40 208L	CAS	SU	RE1	RS1	200		200			200			200
3		OIL-101	10W40 208L	ENI	IT	RE1	RS1	300		300			300			300
4		OIL-102	5W30 208L	Q8	EU	RE1	RS1	120		120			120			120
5		OIL-103	10W40 208L	Q8	EU	RE1	RS1	100		100			100			100
6		S.AG						720	0	720	0	0	720	0	0	720
7	OIL-AS2	OIL-104	10W40 12x1L	Q8	EU	RM1	RC1	123		123			123			123
8		OIL-105	10W40 12x1L	CAS	SU	RM1	RC1	30		30			30			30
9		OIL-106	10W40 12x1L	ENI	IT	RM1	RC1	120		120			120			120
10		OIL-107	15W40 12x1L	CAS	SU	RM1	RC1	0		0			0			0
11		S.AG						273	0	273	0	0	273	0	0	273
12	MS-OIL1	OIL-108	5W30 12x1L	Q8	EU	RRM1	CV1	200		200			200			200
13		OIL-109	10W40 4x4L	Q8	EU	RRM1	CV1	300		300			300			300
14		OIL-110	10W40 4x4L	CAS	SU	RRM1	CV1	230		230			230			230
15		OIL-111	10W40 4x4L	ENI	IT	RRM1	CV1	123		123			123			123
16		OIL-112	5W40 4x4L	Q8	EU	RRM1	CV1	456		456			456			456
17		OIL-113	5W40 4x4L	CAS	SU	RRM1	CV1	234		234			234			234
18		OIL-114	5W40 4x4L	ENI	IT	RRM1	CV1	230		230			230			230
19		OIL-115	20W50 4x4L	Q8	EU	RRM1	CV1	123		123			123			123
20		OIL-116	20W50 4x4L	CAS	SU	RRM1	CV1	560		560			560			560
21		OIL-117	20W50 4x4L	ENI	IT	RRM1	CV1	120		120			120			120
22		OIL-118	5W30 4x4L	Q8	EU	RRM1	CV1	30		30			30			30
23		S.AG						2606	0	2606	0	0	2606	0	0	2606
summary

Cell Formulas
Range	Formula
H11:P11,H6:P6	H6	=SUM(H2:H5)
J12:J22,J7:J10,J2:J5	J2	=H2-I2
P12:P22,P7:P10,P2:P5,M12:M22,M7:M10,M2:M5	M2	=J2+K2-L2
H23:P23	H23	=SUM(H12:H22)

SUM & ADD1.xlsm
	A	B	C	D	E	F	G
1	ITEM	CODE	GOODS	REF	RS.N	BUYING	SELLING
2	1	OIL-104	10W40 12x1L Q8 EU	RM1	RC1	100	10
3	2	OIL-105	10W40 12x1L CAS SU	RM1	RC1	600	5
4	3	OIL-106	10W40 12x1L ENI IT	RM1	RC1	125
5	4	OIL-100	10W40 208L CAS SU	RE1	RS1	200	40
6	5	OIL-107	15W40 12x1L CAS SU	RM1	RC1	131
7	6	OIL-101	10W40 208L ENI IT	RE1	RS1	400	20
8	7	OIL-102	5W30 208L Q8 EU	RE1	RS1	60	20
9	8	OIL-115	20W50 4x4L Q8 EU	RRM1	CV1	10
10	9	OIL-116	20W50 4x4L CAS SU	RRM1	CV1		12
RES

SUM & ADD1.xlsm
	A	B	C	D	E	F
1	ITEM	CODE	GOODS	REF	RS.N	BUYING
2	1	OIL-108	5W30 12x1L Q8 EU	RRM1	CV1	100
3	2	OIL-114	5W40 4x4L ENI IT	RRM1	CV1	20
4	3	OIL-111	10W40 4x4L ENI IT	RRM1	CV1	125
MONTH

SUM & ADD1.xlsm
	A	B	C	D	E	F
1	ITEM	CODE	GOODS	REF	RS.N	SELLING
2	2	OIL-114	5W40 4x4L ENI IT	RRM1	CV1	20
3	3	OIL-111	10W40 4x4L ENI IT	RRM1	CV1	125
MM

RESULT
first time

SUM & ADD1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	CLASSIFICATION	CODE	GOODS	MARK	MANFACTURE	REF	RS.N	BUYING	SELLING	NET	BUYING	SELLING	NET	BUYING	SELLING	NET
2	OIL-AS2	OIL-100	10W40 208L	CAS	SU	RE1	RS1	200		200	200	40	360			360
3		OIL-101	10W40 208L	ENI	IT	RE1	RS1	300		300	400	20	680			680
4		OIL-102	5W30 208L	Q8	EU	RE1	RS1	120		120	60	20	160			160
5		OIL-103	10W40 208L	Q8	EU	RE1	RS1	100		100			100			100
6		S.AG						720	0	720	660	80	1300	0	0	1300
7	OIL-AS2	OIL-104	10W40 12x1L	Q8	EU	RM1	RC1	123		123	100	10	213			213
8		OIL-105	10W40 12x1L	CAS	SU	RM1	RC1	30		30	600	5	625			625
9		OIL-106	10W40 12x1L	ENI	IT	RM1	RC1	120		120	125		245			245
10		OIL-107	15W40 12x1L	CAS	SU	RM1	RC1	0		0	131		131			131
11		S.AG						273	0	273	956	15	1214	0	0	1214
12	MS-OIL1	OIL-108	5W30 12x1L	Q8	EU	RRM1	CV1	200		200	100		300			300
13		OIL-109	10W40 4x4L	Q8	EU	RRM1	CV1	300		300			300			300
14		OIL-110	10W40 4x4L	CAS	SU	RRM1	CV1	230		230			230			230
15		OIL-111	10W40 4x4L	ENI	IT	RRM1	CV1	123		123	125	125	123			123
16		OIL-112	5W40 4x4L	Q8	EU	RRM1	CV1	456		456			456			456
17		OIL-113	5W40 4x4L	CAS	SU	RRM1	CV1	234		234			234			234
18		OIL-114	5W40 4x4L	ENI	IT	RRM1	CV1	230		230	20	20	230			230
19		OIL-115	20W50 4x4L	Q8	EU	RRM1	CV1	123		123	10		133			133
20		OIL-116	20W50 4x4L	CAS	SU	RRM1	CV1	560		560		12	548			548
21		OIL-117	20W50 4x4L	ENI	IT	RRM1	CV1	120		120			120			120
22		OIL-118	5W30 4x4L	Q8	EU	RRM1	CV1	30		30			30			30
23		S.AG						2606	0	2606	255	157	2704	0	0	2704
summary

Cell Formulas
Range	Formula
H11:P11,H6:P6	H6	=SUM(H2:H5)
J12:J22,J7:J10,J2:J5	J2	=H2-I2
P12:P22,P7:P10,P2:P5,M12:M22,M7:M10,M2:M5	M2	=J2+K2-L2
H23:P23	H23	=SUM(H12:H22)

second

SUM & ADD1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	CLASSIFICATION	CODE	GOODS	MARK	MANFACTURE	REF	RS.N	BUYING	SELLING	NET	BUYING	SELLING	NET	BUYING	SELLING	NET
2	OIL-AS2	OIL-100	10W40 208L	CAS	SU	RE1	RS1	200		200	200	40	360	200	40	520
3		OIL-101	10W40 208L	ENI	IT	RE1	RS1	300		300	400	20	680	400	20	1060
4		OIL-102	5W30 208L	Q8	EU	RE1	RS1	120		120	60	20	160	60	20	200
5		OIL-103	10W40 208L	Q8	EU	RE1	RS1	100		100			100			100
6		S.AG						720	0	720	660	80	1300	660	80	1880
7	OIL-AS2	OIL-104	10W40 12x1L	Q8	EU	RM1	RC1	123		123	100	10	213	100	10	303
8		OIL-105	10W40 12x1L	CAS	SU	RM1	RC1	30		30	600	5	625	600	5	1220
9		OIL-106	10W40 12x1L	ENI	IT	RM1	RC1	120		120	125		245	125		370
10		OIL-107	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	MS-OIL1	OIL-108	5W30 12x1L	Q8	EU	RRM1	CV1	200		200	100		300	100		400
13		OIL-109	10W40 4x4L	Q8	EU	RRM1	CV1	300		300			300			300
14		OIL-110	10W40 4x4L	CAS	SU	RRM1	CV1	230		230			230			230
15		OIL-111	10W40 4x4L	ENI	IT	RRM1	CV1	123		123	125	125	123	125	125	123
16		OIL-112	5W40 4x4L	Q8	EU	RRM1	CV1	456		456			456			456
17		OIL-113	5W40 4x4L	CAS	SU	RRM1	CV1	234		234			234			234
18		OIL-114	5W40 4x4L	ENI	IT	RRM1	CV1	230		230	20	20	230	20	20	230
19		OIL-115	20W50 4x4L	Q8	EU	RRM1	CV1	123		123	10		133	10		143
20		OIL-116	20W50 4x4L	CAS	SU	RRM1	CV1	560		560		12	548		12	536
21		OIL-117	20W50 4x4L	ENI	IT	RRM1	CV1	120		120			120			120
22		OIL-118	5W30 4x4L	Q8	EU	RRM1	CV1	30		30			30			30
23		S.AG						2606	0	2606	255	157	2704	255	157	2802
summary

Cell Formulas
Range	Formula
H11:P11,H6:P6	H6	=SUM(H2:H5)
J12:J22,J7:J10,J2:J5	J2	=H2-I2
P12:P22,P7:P10,P2:P5,M12:M22,M7:M10,M2:M5	M2	=J2+K2-L2
H23:P23	H23	=SUM(H12:H22)

and so on every time should add & sum to last columns SELLING & BUYING

 

[leap out]

can any body help ?