delete column from sheet and move values ,sum to another sheet

[abdo meghari]

hello
I have two sheets . the first contains values for two columns C,D , the other sheet contains values in column C what I want matching the items based on column B for two sheets . and delete the column D from first sheet and summing the values over each item in column C for the second sheet.
the data are about 1900 rows and will increase.

REPORT.xlsm
	A	B	C	D
1	ITEM	BRAND	SALES	RETURNS
2	1	BS 1200R20 G580 TCF JAP	152	10
3	2	BS 1200R24 G582 JAP	94	0
4	3	BS 1400R20 VSJ TCF JAP	21	0
5	4	BS 155 R12C R623 JAP	18	0
6	5	BS 155 R12C R624 INDO	4	4
7	6	BS 165 R13C R624 INDO	8	4
8	7	BS 175/70 R13 EP150 THI	4	0
9	8	BS 175/70 R14 EP150 THI	8	0
10	9	BS 185/65 R14 EP150 INDO	8	4
11	10	BS 185/65 R14 TEC THI	8	0
12	11	BS 185/65 R15 T005 INDO	4	4
13	12	BS 185/70 R13 EP150 INDO	8	4
14	13	BS 185R14C R624 INDO	4	0
15	14	BS 195 R14C 613 JAP	12	4
16	15	BS 195 R15C R623 THI	6	4
17	16	BS 195/55 R16 EP300 THI	4	4
18	17	BS 195/60 R15 EP150 THI	12	4
19	18	BS 195/65 R15 EP15 JAP	8	0
20	19	BS 195/70 R15C R623 JAP	8	4
21	20	BS 195/75 R16C R613 JAP	4	4
22	21	BS 205/60 R16 T001 JAP	4	0
23	22	BS 205/65 R15 EP150 INDO	6	4
24	23	BS 215/45 R17 T001 JAP	4	4
25	24	BS 215/55 R16 EP300 INDO	4	4
26	25	BS 215/55 R17 MY-02 THI	8	4
27	26	BS 215/55 R17 T005 JAP	4	0
28	27	BS 215/55 R17 TG90 INDO	16	4
29	28	BS 215/60 R16 EP30 THI	4	2
30	29	BS 215/65 R16C R611 THI	8	4
31	30	BS 215/70 R15C R623 THI	23	4
32	31	BS 225/55 R16 T001 JAP	4	0
33	32	BS 225/55 R17 EP300 THI	12	4
34	33	BS 225/60 R16 EP300 JAP	10	0
35	34	BS 225/60 R16 T001 JAP	4	0
36	35	BS 225/60 R17 D-SPORT JAP	4	4
37	36	BS 225/70 R15C R623 JAP	8	0
38	37	BS 225/70 R16 D687 JAP	8	4
39	38	BS 225/70 R16 H005 THI	4	0
40	39	BS 225/70 R17 D697 THI	4	0
41	40	BS 235/55 R17 ER30 JAP	4	4
42	41	BS 235/55 R17 T005 THI	4	0
43	42	BS 235/55 R18 E031 JAP	8	0
44	43	BS 235/60 R16 T01 JAP	4	0
45	44	BS 235/60 R17 D400 JAP	8	4
46	45	BS 245/40 ZR20 S001 JAP	4	0
47	46	BS 245/45 R19 T005 JAP	4	0
48	47	BS 245/70 R16 D684 THI	4	4
49	48	BS 245/70 R17 D684 JAP	38	0
50	49	BS 245/75 R17 693A JAP	4	0
51	50	BS 255/70 R16 H005 THI	4	4
52	51	BS 265/50 R20 D-SPORT JAP	4	0
53	52	BS 265/60R18 D840 JAP	12	0
54	53	BS 265/70 R18 D684 JAP	4	0
55	54	BS 275/40 R18 S007 JAP	4	0
56	55	BS 275/40 R20 DSPORT JAP	4	0
57	56	BS 275/45 R19 ALENZA JAP	4	0
58	57	BS 275/55 R17 DSPORT JAP	4	0
59	58	BS 275/70 R16 D694 JAP	4	0
60	59	BS 275/70 R16 H005 THI	4	4
61	60	BS 285/60 R18 T01 JAP	8	4
62	61	BS 285/65 R17 R683 JAP	8	4
63	62	BS 315/80 R22.5 G580 JAP	8	0
64	63	BS 315/80 R22.5 R152 JAP	4	0
65	64	BS 315/80 R22.5 R184 JAP	0	1
66	65	BS 385/65 R22.5 R164 JAP	105	121
67	66	BS 445/65 R22.5 R164 JAP	4	0
68	67	BS 650R16 R230 JAP	16	0
69	68	BS 750R16 R230 TCF JAP	74	0
70	69	BS 750R16 VSJ TCF JAP	112	0
71	70	BS 8.25R16 R180 JAP	0	1
72	71	Dayton 315/80R22.5 DS50 THI	0	10
73	72	FS 1200 R24 FSR4000 JAP	2	20
74	73	FS 205/65 R15 TZ700 JAP	4	4
75	74	FS 215/55 R17 TZ700 JAP	8	4
76	75	FS 225/45 R17 TZ700 JAP	4	4
SH1

REPORT.xlsm
	A	B	C
1	ITEM	BRAND	BALANCE
2	1	BS 195 R14C 613 JAP	12
3	2	BS 175/70 R13 EP150 THI	4
4	3	BS 1400R20 VSJ TCF JAP	21
5	4	BS 1200R20 G580 TCF JAP	152
6	5	BS 1200R24 G582 JAP	94
7	6	BS 155 R12C R623 JAP	18
8	7	BS 155 R12C R624 INDO	4
9	8	BS 165 R13C R624 INDO	8
10	9	BS 195 R15C R623 THI	6
11	10	BS 195/55 R16 EP300 THI	4
12	11	BS 175/70 R14 EP150 THI	8
13	12	BS 185/65 R14 EP150 INDO	8
14	13	BS 185/65 R14 TEC THI	8
15	14	BS 185/65 R15 T005 INDO	4
16	15	BS 185/70 R13 EP150 INDO	8
17	16	BS 185R14C R624 INDO	4
SH2

result

REPORT.xlsm
	A	B	C
1	ITEM	BRAND	SALES
2	1	BS 1200R20 G580 TCF JAP	152
3	2	BS 1200R24 G582 JAP	94
4	3	BS 1400R20 VSJ TCF JAP	21
5	4	BS 155 R12C R623 JAP	18
6	5	BS 155 R12C R624 INDO	4
7	6	BS 165 R13C R624 INDO	8
8	7	BS 175/70 R13 EP150 THI	4
9	8	BS 175/70 R14 EP150 THI	8
10	9	BS 185/65 R14 EP150 INDO	8
11	10	BS 185/65 R14 TEC THI	8
12	11	BS 185/65 R15 T005 INDO	4
13	12	BS 185/70 R13 EP150 INDO	8
14	13	BS 185R14C R624 INDO	4
15	14	BS 195 R14C 613 JAP	12
16	15	BS 195 R15C R623 THI	6
17	16	BS 195/55 R16 EP300 THI	4
18	17	BS 195/60 R15 EP150 THI	12
19	18	BS 195/65 R15 EP15 JAP	8
20	19	BS 195/70 R15C R623 JAP	8
21	20	BS 195/75 R16C R613 JAP	4
22	21	BS 205/60 R16 T001 JAP	4
23	22	BS 205/65 R15 EP150 INDO	6
24	23	BS 215/45 R17 T001 JAP	4
25	24	BS 215/55 R16 EP300 INDO	4
26	25	BS 215/55 R17 MY-02 THI	8
27	26	BS 215/55 R17 T005 JAP	4
28	27	BS 215/55 R17 TG90 INDO	16
29	28	BS 215/60 R16 EP30 THI	4
30	29	BS 215/65 R16C R611 THI	8
31	30	BS 215/70 R15C R623 THI	23
32	31	BS 225/55 R16 T001 JAP	4
33	32	BS 225/55 R17 EP300 THI	12
34	33	BS 225/60 R16 EP300 JAP	10
35	34	BS 225/60 R16 T001 JAP	4
36	35	BS 225/60 R17 D-SPORT JAP	4
37	36	BS 225/70 R15C R623 JAP	8
38	37	BS 225/70 R16 D687 JAP	8
39	38	BS 225/70 R16 H005 THI	4
40	39	BS 225/70 R17 D697 THI	4
41	40	BS 235/55 R17 ER30 JAP	4
42	41	BS 235/55 R17 T005 THI	4
43	42	BS 235/55 R18 E031 JAP	8
44	43	BS 235/60 R16 T01 JAP	4
45	44	BS 235/60 R17 D400 JAP	8
46	45	BS 245/40 ZR20 S001 JAP	4
47	46	BS 245/45 R19 T005 JAP	4
48	47	BS 245/70 R16 D684 THI	4
49	48	BS 245/70 R17 D684 JAP	38
50	49	BS 245/75 R17 693A JAP	4
51	50	BS 255/70 R16 H005 THI	4
52	51	BS 265/50 R20 D-SPORT JAP	4
53	52	BS 265/60R18 D840 JAP	12
54	53	BS 265/70 R18 D684 JAP	4
55	54	BS 275/40 R18 S007 JAP	4
56	55	BS 275/40 R20 DSPORT JAP	4
57	56	BS 275/45 R19 ALENZA JAP	4
58	57	BS 275/55 R17 DSPORT JAP	4
59	58	BS 275/70 R16 D694 JAP	4
60	59	BS 275/70 R16 H005 THI	4
61	60	BS 285/60 R18 T01 JAP	8
62	61	BS 285/65 R17 R683 JAP	8
63	62	BS 315/80 R22.5 G580 JAP	8
64	63	BS 315/80 R22.5 R152 JAP	4
65	64	BS 315/80 R22.5 R184 JAP	0
66	65	BS 385/65 R22.5 R164 JAP	105
67	66	BS 445/65 R22.5 R164 JAP	4
68	67	BS 650R16 R230 JAP	16
69	68	BS 750R16 R230 TCF JAP	74
70	69	BS 750R16 VSJ TCF JAP	112
71	70	BS 8.25R16 R180 JAP	0
72	71	Dayton 315/80R22.5 DS50 THI	0
73	72	FS 1200 R24 FSR4000 JAP	2
SH1

REPORT.xlsm
	A	B	C
1	ITEM	BRAND	BALANCE
2	1	BS 195 R14C 613 JAP	16
3	2	BS 175/70 R13 EP150 THI	4
4	3	BS 1400R20 VSJ TCF JAP	21
5	4	BS 1200R20 G580 TCF JAP	162
6	5	BS 1200R24 G582 JAP	94
7	6	BS 155 R12C R623 JAP	18
8	7	BS 155 R12C R624 INDO	22
9	8	BS 165 R13C R624 INDO	12
10	9	BS 195 R15C R623 THI	10
11	10	BS 195/55 R16 EP300 THI	8
12	11	BS 175/70 R14 EP150 THI	8
13	12	BS 185/65 R14 EP150 INDO	12
14	13	BS 185/65 R14 TEC THI	8
15	14	BS 185/65 R15 T005 INDO	8
16	15	BS 185/70 R13 EP150 INDO	12
17	16	BS 185R14C R624 INDO	4
SH2

 

[abdo meghari]

my apologies !
ignore two duplicates items should not be then should not be new and doesn't supposes adding to SH2

REPORT.xlsm
	A	B	C
1	ITEM	BRAND	BALANCE
2	1	BS 195 R14C 613 JAP	16
3	2	BS 175/70 R13 EP150 THI	4
4	3	BS 1400R20 VSJ TCF JAP	21
5	4	BS 1200R20 G580 TCF JAP	162
6	5	BS 1200R24 G582 JAP	94
7	6	BS 155 R12C R623 JAP	18
8	7	BS 155 R12C R624 INDO	8
9	8	BS 165 R13C R624 INDO	12
10	9	BS 195 R15C R623 THI	10
11	10	BS 195/55 R16 EP300 THI	8
12	11	BS 175/70 R14 EP150 THI	8
13	12	BS 185/65 R14 EP150 INDO	12
14	13	BS 185/65 R14 TEC THI	8
15	14	BS 185/65 R15 T005 INDO	8
16	15	BS 185/70 R13 EP150 INDO	12
17	16	BS 185R14C R624 INDO	4
18	17	BS 195/60 R15 EP150 THI	4
19	18	BS 195/70 R15C R623 JAP	4
20	19	BS 195/75 R16C R613 JAP	4
21	20	BS 205/65 R15 EP150 INDO	4
22	21	BS 215/45 R17 T001 JAP	4
23	22	BS 215/55 R16 EP300 INDO	4
24	23	BS 215/55 R17 MY-02 THI	4
25	24	BS 215/55 R17 TG90 INDO	4
26	25	BS 215/60 R16 EP30 THI	2
27	26	BS 215/65 R16C R611 THI	4
28	27	BS 215/70 R15C R623 THI	4
29	28	BS 225/55 R17 EP300 THI	4
30	29	BS 225/60 R17 D-SPORT JAP	4
31	30	BS 225/70 R16 D687 JAP	4
32	31	BS 235/55 R17 ER30 JAP	4
33	32	BS 235/60 R17 D400 JAP	4
34	33	BS 245/70 R16 D684 THI	4
35	34	BS 255/70 R16 H005 THI	4
36	35	BS 275/70 R16 H005 THI	4
37	36	BS 285/60 R18 T01 JAP	4
38	37	BS 285/65 R17 R683 JAP	4
39	38	BS 315/80 R22.5 R184 JAP	1
40	39	BS 385/65 R22.5 R164 JAP	121
41	40	BS 8.25R16 R180 JAP	1
42	41	Dayton 315/80R22.5 DS50 THI	10
43	42	FS 1200 R24 FSR4000 JAP	20
44	43	FS 205/65 R15 TZ700 JAP	4
45	44	FS 215/55 R17 TZ700 JAP	4
46	45	FS 225/45 R17 TZ700 JAP	4
SH2

 

[abdo meghari]

I tested . your code work excellently
many thanks for your help & time

 

[Alex Blakenburg]

Glad we got there. Thanks for letting me know.