Location Wise Stock with Multiple Receipts & Issuance Transactions

[Rajeshkumar R]

Dear Friends,

In the Attached Excel File “Table7” contains data from Column A to Column V

Column A contains Product Lists

Column L contains Qty (Is this Qty Receipts (Inbound) or Issuance (Outbound)) details available in Column N “Transaction Type”

Column S is the Unique Code of a Product

Support Required: -

Column T, U & V there is Formula exist which is working fine, however my database is dynamic and on daily basis minimum 500+ Rows would get added, which is resulting me in making
the file very very slow

So, Requesting you to suggest a VBA based solution to get the same result which is there in Column T, U & V, So that I can call that macro only when required…

Note :
1. Column U & V Result the suggestion was already given by Mr. Leonguyenz available in below link suggested code, where Receipts (Inbound) and Issuance (Outbound)) independent in set of Rows…

https://www.excelforum.com/excel-pro...t=#post5612130

3. In the current attached file Receipts (Inbound) and Issuance (Outbound)) both mixed together, So new suggested code should consider this and provide the Result…
Looking forward, your valuable Input…

Thanks & Regards,
Rajeshkumar R

[Rajeshkumar R]

Dear Experts,

Could you please let me know, any additional details required on my above Request?

Thanks & Regards,
Rajeshkumar R

[Rajeshkumar R]

Dear Experts,

Could you please help me to understand, Is my above request impossible to make it in Excel?

Thanks & Regards,
Rajeshkumar R