Hello all, first post here!
I could use some help with the following problem. I have a list of Customers and each purchase they have made by receipt # and item. However my employer would like to be able to find the total of each receipt while still being able to see each item bought. There is a variable number if items in each receipt.
If anyone has any suggestions that may work (either through formulas and/or VBA) it would be very appreciated!
Current Data
<tbody>
</tbody>
If I consolidate the rows, I will have the total for each receipt, but the item numbers would no longer match up with the receipt number.
Consolidate Result (not good)
<tbody>
</tbody>
Desired Result (return total to top of each repeated receipt number)
<tbody>
</tbody>
Any help is very appreciated!
I could use some help with the following problem. I have a list of Customers and each purchase they have made by receipt # and item. However my employer would like to be able to find the total of each receipt while still being able to see each item bought. There is a variable number if items in each receipt.
If anyone has any suggestions that may work (either through formulas and/or VBA) it would be very appreciated!
Current Data
Receipt Number | Total | Item Number |
123456 | $10.00 | 17453 |
123456 | $15.00 | 71664 |
123456 | $10.00 | 37489 |
111111 | $100.00 | 76514 |
222222 | $25.00 | 66964 |
333333 | $100.00 | 34686 |
333333 | $50.00 | 48633 |
333333 | $25.00 | 75434 |
333333 | $20.00 | 66834 |
<tbody>
</tbody>
If I consolidate the rows, I will have the total for each receipt, but the item numbers would no longer match up with the receipt number.
Consolidate Result (not good)
Receipt Number | Total | Item Number |
123456 | $35.00 | 17453 |
111111 | 100.00 | 71664 |
222222 | 25.00 | 37489 |
333333 | 195.00 | 76514 |
66964 | ||
34686 | ||
48633 | ||
75434 | ||
66834 |
<tbody>
</tbody>
Desired Result (return total to top of each repeated receipt number)
Receipt Number | Total | Item Number |
123456 | 35.00 | 17453 |
123456 | 71664 | |
123456 | 37489 | |
111111 | 100.00 | 76514 |
222222 | 25.00 | 66964 |
333333 | 195.00 | 34686 |
333333 | 48633 | |
333333 | 75434 | |
333333 | 66834 |
<tbody>
</tbody>
Any help is very appreciated!