VB Code to calculate amount from transfer of inventory

[rizmomin]

Hello:

Please refer to attached file.
I have data as shown.
This data shows inventory transfer from one store to another.
Column B and C are Store name.
Column G is Qty transfer and column H is Unot cost and Column I is total cost.

I need VB Code to do following

I need to create Invoice for each store for what they owe to each other.
My logic here is as below.

1st sort out the data for same 2 stores transfer (from and to, To and From).

Example
Row#2 and 3 shows Transfer from BN to WE (Cost is $6 and $14.40 = $20.40)
Now look for any transfer from WE to BN
Row#25 and #27 shows transfer from WE to BN (Cost is $21.60 and $42 = $63.60).

So now i would need output in sheet2 as shown

Let me know if you have any questions.
Thanks.

Riz