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.

Product code	qty	Price buying	Selling £	Total
A1234	3	20	30	90
A1234	3	20	30	90
A1235	3	20	30	90
results are like
A1234	6
A1235	3

<tbody>
</tbody>

 

[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