Hi Experts,
I apologize if i am not explain my request clearly.
On the below example I would like sum all the same customers total and also the Due amount.
then i would like to divide the Due by the Total.
The result I would like in a msg box..or on a new worksheet
example
TestA is X%
TestB is X%
TestC is X%
The problem is I will never know how many different customers there will be or how many different account, so some flexibility is needed to accommodate this.
Is this request possible?
example.JPG
Bookmarks