Formula transpose - VBA

Hi, I have a project that required some VBA to perform some calculations. I have attached a file with the manual calculations that I need to be done through VBA. To explain, I have two sheets in Excel. In the first sheet, named ‘Actual’, I have a formula that calculates the amount of money that has left a product, as a percentage. This calculation is performed only on those transactions with the transaction code “SWI”. Please note, I do not need this calculation through VBA, I have already written the code for this. In the second sheet, named ‘Alternative’, the same percentages are applied to the exact same transactions that are listed in the ‘Actual’ sheet. Then a formula in column V is input. The formula multiplies the percentage by the previous listing of the products cumulative units by the current price of the product. Please note that the previous listing of the product could be any number of rows prior to the current row. The final step is to adjust the debit or credit amount in column K or L to the new amount calculated in column V, as a value, not a formula. Please see the attached sheet for details of the calculation that I need, thanks for your help