Products se vba to sum qty

[Graham JN]

Help lol
i have data in a sheet and it is variable number of rows always changes.
within each row of data is various columns of data.
i would like it to consolidate the data to a new sheet so that any identical product codes are consolidated so I just have number of products for each code.

[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Product code
[/TD]
[TD]qty[/TD]
[TD]Price buying[/TD]
[TD]Selling £[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]A1234[/TD]
[TD]3[/TD]
[TD]20[/TD]
[TD]30[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]A1234[/TD]
[TD]3[/TD]
[TD]20[/TD]
[TD]30[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]A1235[/TD]
[TD]3[/TD]
[TD]20[/TD]
[TD]30[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]results are like[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A1234[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A1235[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Learn Excel in Tamil]

Hi ,

Please advice you need output only for product code and quantity Or all headers

Thanks
Happy learning
Learn excel in Tamil

 

[Graham JN]

just the product code and qty

 

[Peter_SSs]

Welcome to the MrExcel board!

Excel's built-in Pivot Table feature can do that for you.

1. Select A1:B(end of data) That is Product code & qty columns, including headings.
2. 'Insert' ribbon tab -> PivotTable -> OK
That should produce a new sheet with a PivotTable panel at the right. In that panel ..
3. Click & drag Product code text from the top section to the 'Rows' section at bottom left
4. Click & drag the qty text from the top section to the 'Values' section at the bottom right
All done

Here is the result for me:

Excel Workbook
	A	B
1
2
3	Row Labels	Sum of qty
4	A1234	6
5	A1235	3
6	Grand Total	9
7
Sheet5