Hi
I have two worksheets. Worksheet 'detail' contains details of sales transactions (values). Each row shows a Customer code, and transaction values. The transactions appear in multiple columns under different 'groups', as below.
image does not work so please see cut & paste from Excel
<colgroup><col><col span="5"></colgroup><tbody>
</tbody>
I need to be able to summarise this data in another worksheet which has the same basic layout, but contains a summary total for each Customer, as below.
image does not work so please see cut & paste from Excel
<colgroup><col><col span="5"></colgroup><tbody>
</tbody>
NOTE: this is part of a much larger VB set of codes, and normally includes 50+ customers and around 30 groups, but I am after the principle and thought it best to minimise the examples.
Any help on this would be really appreciated, as I have spent hours looking at code snippets.
I have two worksheets. Worksheet 'detail' contains details of sales transactions (values). Each row shows a Customer code, and transaction values. The transactions appear in multiple columns under different 'groups', as below.
image does not work so please see cut & paste from Excel
Customer | 10CC | 10CE | 10IH | 10IJ | 10QE |
A01 | 528.6 | 0 | 550.8898 | 0 | 25.99 |
A01 | 17.4 | 665.22 | 0 | 0 | 44.33 |
A01 | 22.45 | 0 | 0 | 22.66 | 0 |
B02 | 0 | 0 | 393.72 | 0 | 0 |
B02 | 0 | 123.78 | 36.06911 | 0 | 1.12 |
B02 | 0 | 22 | 14.4129 | 0 | 0 |
G02 | 0 | 88.34 | 4597.003 | 0 | 15.15 |
G02 | 0 | 0 | 220.3848 | 0 | 0 |
G02 | 0 | 0 | 160.716 | 0 | 0 |
G02 | 0 | 0 | 1173.903 | 0 | 0 |
<colgroup><col><col span="5"></colgroup><tbody>
</tbody>
I need to be able to summarise this data in another worksheet which has the same basic layout, but contains a summary total for each Customer, as below.
image does not work so please see cut & paste from Excel
Customer | 10CC | 10CE | 10IH | 10IJ | 10QE |
A01 | 568.45 | 665.22 | 550.8898 | 22.66 | 70.32 |
B02 | 0 | 145.78 | 444.202 | 0 | 1.12 |
G02 | 0 | 88.34 | 6152.007 | 0 | 15.15 |
<colgroup><col><col span="5"></colgroup><tbody>
</tbody>
NOTE: this is part of a much larger VB set of codes, and normally includes 50+ customers and around 30 groups, but I am after the principle and thought it best to minimise the examples.
Any help on this would be really appreciated, as I have spent hours looking at code snippets.
Last edited: