Need help with a macro

[mrobertware]

Hello,

I am needing help creating a macro that combines part numbers and qty's. For instance, if i have 5 rows of part A, with qty's of 4, I would like the output to show 1 row with a qty of 20. I would like for macro to cover 800 rows (I could have less but no more than 800).

I have sample data.

 

[kevin9999]

Seeing as you have 365, and rather than using VBA, how about:

Book1
	A	B	C	D	E
1	Item Num	Qty		Item Num	Qty
2	71420534	1		71420534	11
3	71420534	1		71303200	8
4	71420534	1		MH0001	9
5	71420534	1
6	71420534	4
7	71420534	1
8	71303200	1
9	71303200	1
10	71303200	1
11	71303200	3
12	71420534	1
13	71420534	1
14	MH0001	1
15	71303200	1
16	71303200	1
17	MH0001	4
18	MH0001	1
19	MH0001	1
20	MH0001	1
21	MH0001	1
Sheet1

Cell Formulas
Range	Formula
D2:D4	D2	=UNIQUE(FILTER(A2:A801,A2:A801<>""))
E2:E4	E2	=SUMIFS(B2:B801,A2:A801,D2#)
Dynamic array formulas.

 

[mrobertware]

Ohhh thank you so much!!!!!

 

[Michael M]

Could also us a Pivot Table...no formula required

Book1
	A	B	C	D	E
1	Item	Qty
2	71420534	1
3	71420534	1
4	71420534	1		Row Labels	Sum of Qty
5	71420534	1		71303200	8
6	71420534	4		71420534	11
7	71420534	1		MH0001	9
8	71303200	1		Grand Total	28
9	71303200	1
10	71303200	1
11	71303200	3
12	71420534	1
13	71420534	1
14	MH0001	1
15	71303200	1
16	71303200	1
17	MH0001	4
18	MH0001	1
19	MH0001	1
20	MH0001	1
21	MH0001	1
Sheet1