Dear All Excel Experts
I have my sheets: Clients, Payments, Statement
In the Statement sheet I tried my best that Excel automatically looks for the payment of the client and decides "Paid" or "Unpaid", but in vain.
I have hope that experts will help my solve this problem.
By the way the payment is the same number of the invoice amount; client has many invoices and many payments
File is attached looking for your help on this link:
https://www.officena.net/ib/topic/8...واضافة-مدفوع-او-غير-مدفوع-في-جدول-كشف-الحساب/
Jihad
I have my sheets: Clients, Payments, Statement
In the Statement sheet I tried my best that Excel automatically looks for the payment of the client and decides "Paid" or "Unpaid", but in vain.
I have hope that experts will help my solve this problem.
By the way the payment is the same number of the invoice amount; client has many invoices and many payments
File is attached looking for your help on this link:
https://www.officena.net/ib/topic/8...واضافة-مدفوع-او-غير-مدفوع-في-جدول-كشف-الحساب/
Jihad