Sorting and combining multiple criteria into single result on multiple sheets

[dugus]

Hi Guys

On sheet 1 I have invoice totals input for various suppliers on various dates. They are not input in date order or supplier order but as they are taken off the pile. I need to take all that data and sort it on sheet 2 by supplier(Column B) and then date (Column D). Multiple invoices for the same date and same supplier need to be added together as per D3 on sheet 2.

Thank you for any help you can give.



[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD="align: center"]Sheet 1[/TD]
[TD="width: 114, align: center"]A[/TD]
[TD="width: 176, align: center"]B[/TD]
[TD="width: 160, align: center"]C[/TD]
[TD="width: 76, align: center"]D[/TD]
[TD="width: 84, align: center"]E[/TD]
[TD="width: 87, align: center"]F[/TD]
[/TR]
[TR]
[TD="width: 114, align: center"]1[/TD]
[TD="width: 114"]Type[/TD]
[TD="width: 176"]Account Reference[/TD]
[TD="width: 160"]Nominal A/C Ref[/TD]
[TD="width: 76"]Date[/TD]
[TD="width: 84"]Reference: INVOICE NUMBER[/TD]
[TD="width: 87"]Net Amount[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Purchase Invoice[/TD]
[TD]Supplier 1[/TD]
[TD]2201[/TD]
[TD="align: right"]01/08/2017[/TD]
[TD][/TD]
[TD="align: right"]88.03[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Purchase Invoice[/TD]
[TD]Supplier 1[/TD]
[TD]2201[/TD]
[TD="align: right"]03/08/2017[/TD]
[TD][/TD]
[TD="align: right"]107.46[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Purchase Invoice[/TD]
[TD]Supplier 2[/TD]
[TD]2201[/TD]
[TD="align: right"]03/08/2017[/TD]
[TD][/TD]
[TD="align: right"]128.35[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]Purchase Invoice[/TD]
[TD]Supplier 2[/TD]
[TD]2201[/TD]
[TD="align: right"]01/08/2017[/TD]
[TD][/TD]
[TD="align: right"]67.42[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]Purchase Invoice[/TD]
[TD]Supplier 2[/TD]
[TD]2201[/TD]
[TD="align: right"]02/08/2017[/TD]
[TD][/TD]
[TD="align: right"]199.31[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]Purchase Invoice[/TD]
[TD]Supplier 2[/TD]
[TD]2201[/TD]
[TD="align: right"]03/08/2017[/TD]
[TD][/TD]
[TD="align: right"]38.89[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]Purchase Invoice[/TD]
[TD]Supplier 4[/TD]
[TD]2201[/TD]
[TD="align: right"]05/08/2017[/TD]
[TD][/TD]
[TD="align: right"]42.02[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]Purchase Invoice[/TD]
[TD]Supplier 3[/TD]
[TD]2201[/TD]
[TD="align: right"]03/08/2017[/TD]
[TD][/TD]
[TD="align: right"]58.67[/TD]
[/TR]
</tbody>[/TABLE]




[TABLE="class: outer_border, width: 1083"]
<tbody>[TR]
[TD="align: center"]Sheet 2[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]SUPPLIERS[/TD]
[TD]01-Jan[/TD]
[TD]02-Jan[/TD]
[TD]03-Jan[/TD]
[TD]04-Jan[/TD]
[TD]05-Jan[/TD]
[TD]06-Jan[/TD]
[TD]07-Jan[/TD]
[TD]08-Jan[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Supplier 1[/TD]
[TD] 88.03[/TD]
[TD][/TD]
[TD] 107.46[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Supplier 2[/TD]
[TD] 67.42[/TD]
[TD]199.31[/TD]
[TD] 167.24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Supplier 3[/TD]
[TD][/TD]
[TD][/TD]
[TD] 58.67[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]Supplier 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 42.02[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]Supplier 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]Supplier 6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]Supplier 7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]Supplier 8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD]Supplier 9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD]Supplier 10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD]Supplier 11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD]Supplier 12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD]Petty Cash[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]