Pamella
08-08-2019, 11:53 PM
Hi All,
Please can you help me with the coding for this.
In Sheet called "Balance" there can be multiple entries of different currencies.
1) ADD amounts for same currency if Col I Amount is negative
2) Minus amounts for same currency is Col Amount I is positive
3) If no entries starting at G2 then just take the amount from Col C for that currency
Col A TDate 04/12/2019
Col B Currency GBP
Col C Amount 0.07
Col D ID 234kjhkjh23
Col G PenDate 07/12/2019
Col H Currency GBP
Col I Amount 2123,999
Col J ID 234kjhkjh23
Output should be in "Output" sheet. Find next empty row and paste Id in col A. In the same row paste the Amount under the same currency which is in Row 1.
Please can you help me with the coding for this.
In Sheet called "Balance" there can be multiple entries of different currencies.
1) ADD amounts for same currency if Col I Amount is negative
2) Minus amounts for same currency is Col Amount I is positive
3) If no entries starting at G2 then just take the amount from Col C for that currency
Col A TDate 04/12/2019
Col B Currency GBP
Col C Amount 0.07
Col D ID 234kjhkjh23
Col G PenDate 07/12/2019
Col H Currency GBP
Col I Amount 2123,999
Col J ID 234kjhkjh23
Output should be in "Output" sheet. Find next empty row and paste Id in col A. In the same row paste the Amount under the same currency which is in Row 1.