Hi Below is 2 data fields, the first data shows current data and subsequant, I did ask a earlier question about getting it show on the individual ID's which was answered ( thanks!) what I ned is for it to add up. SO for order 3 there was actual 3 items and the quantities were 123 each, I need on a subsequant sheet for it to add up where there is a blank until it reaches order ID 4
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
ID | Quantity |
1 | 12 |
2 | 123 |
3 | 123 |
123 | |
123 | |
4 | 13 |
5 | 123 |
6 | 23 |
Result wanting | |
ID | Quantity |
1 | 12 |
2 | 123 |
3 | 346 |
4 | 13 |
5 | 123 |
6 | 23 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>