July 10, 2021
Am using inventory management application in excel. I need one suggestion for adopt formula to my range.
Explanation: this range of data is in range("E11:P18")
Example, The paid amount is 1,000 (Paid Rs) respect to the user And (To wallet) will automatically fill PAID - TOTAL
In that amount can distribute to other cells in (wallet used) column respect to user. How to solve this issues.
I want only formula or VBA requirement of wallet used column, and all others are working in vba.
|Id No||Date||Party||Qty||Price||Wallet Used||Total||Paid On||Paid Rs||To Wallet||Balance||Status|
|1001||28-06-2021||Chandra Mohan M. R.||12||420||420||07-07-2021||1000||580||PAID|
|1004||06-07-2021||Chandra Mohan M. R.||1||35||?||35||35||DUE|
|1005||07-07-2021||Chandra Mohan M. R.||1||35||?||35||35||DUE|
|1006||09-07-2021||Chandra Mohan M. R.||4||140||?||140||140||DUE|
|1007||10-07-2021||Chandra Mohan M. R.||2||90||?||90||90||DUE|
Thank you by
December 7, 2016
See attached file for a formula solution, I have renamed and rearranged your data range to make it a little bit easier for me to work with.
As it is easy to get stuck with circular references using the formula approach I do think this would be better solved using VBA.
Hope this gives you some direction on how to solve your issue.