I have 2 sheets in a workbook.
The first sheet ‘kit list’ has a table with a drop down boxin B12 to B210, so I can select a product from the drop down, then in C12 to C210,I can put the number of each of the products I want. There could be multiplevalues that are the same in column B.
| Site|| Product|| Qty|
| Moor Street|| Product A|| 10|
| Moor Street|| Product B|| 40|
| Moor Street|| Product C|| 32|
| John Street|| Product A|| 16|
| Blue Street|| Product A|| 8|
| Blue Street|| Product C|| 1|
| Green Street|| Product B|| 14|
| Green Street|| Product C|| 82|
| Orange Street|| Product C|| 34|
| Orange Street|| Product A|| 14|
In the second sheet ’bill of materials’ I want to then createa list from the information from the first sheet listing all the unique valuesand a count of the number of these value.
| Product|| Qty|
| Product A|| 48|
| Product B|| 54|
| Product C|| 149|
Now imagine if there are multiple columns in the first sheetwith different floors
| Floor1|| Floor2|| Floor3|