Convert Detail Inventory to Summary

[TampaMike]

A friend referred me to this site and thought it was worth a try.

I have a detailed inventory that is in columns. The two columns I am concerned about are location and product. The sheet has 1600 rows of locations and products. Each row is an individual inventory entry. There are about 80 locations right now and 10 product types. The locations will continue to increase to about 250 locations, but the number of product types will stay constant at 10. The number of rows will grow to 5000.

I want a summary page that will give a total number of products by sites. The finished report would have the location in column A and the total number of products in B to K. The next row would have a new location and so on.

Is there a solution already on the board? Is this something that could be done in a Macro or Formula?

Thanks,

Mike

 

[VoG]

I think that you need a Pivot Table. Tutorials here http://www.contextures.com/tiptech.html