Hello users,
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 | ||
| 1002 | 30-06-2021 | Shyla | 1 | 300 | 300 | 07-07-2021 | 600 | 300 | PAID | ||
| 1003 | 02-07-2021 | Shyla | 1 | 300 | 300 | 0 | 0 | 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
Kiran
Hello Kiran,
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.
Br,
Anders
