Updation of data in one sheet to another sheet

[sajeevjvarma]

Based on the PAID column in BOOKS-ACC ,
1. Amount has to be adjusted in GTB,WB,NB,STAT
Ex: Suppose AMOUNT is 3770 then and PAID is 3000 then
it has to be distributed in GTB,WB,NB,STAT accordingly.

2. Based on the Date column in BOOKS-ACC,
Automatically,
SUMMARY sheet columns has to be summed up.

KIndly help me solving the problem.

Sample-Sheet.xlsx

[JohnTopley]

it has to be distributed in GTB,WB,NB,STAT accordingly.

so what are the distribution rule(s)?

[sajeevjvarma]

Thank you for your quick reply Sir....
For Example,
AMOUNT is 3770 and PAID is 3000.
Originally it should be
XYZ CLASS-IV 3770.00 760.00 1163.00 540.00 1300.00 3770.00 0.00
But as per the distribution rule , it should be
XYZ CLASS-IV 3770.00 760.00 1163.00 540.00 530.00 3000.00 770.00
Hope you understand....

[JeteMc]

Telling us what the amounts are expected to be does not tell us why the amounts are expected to be that way.
Please explain why J24 should display 530.00 instead of 1300.00

[sajeevjvarma]

Thank you Sir..
AMOUNT is 3770 and PAID is 3000.
Originally it should be
XYZ CLASS-IV 3770.00 760.00 1163.00 540.00 1300.00 3770.00 0.00
But as per the distribution rule , it should be
XYZ CLASS-IV 3770.00 760.00 1163.00 540.00 530.00 3000.00 770.00

The 3000 in PAID column is to be adjusted starting from G24,H24,I24 and then J24 Sir
That is , First 3000-G24, 3000-760=2240 then 2240-H24, 2240-1163=1077 then 1077-I24, 1077-540=537 so I24 is 537, not 530 i have just rounded it.
If 0 is in PAID column then G24 to I24 should be 0.
Hope now you understand it...

[JeteMc]

Received as a private message:

Good Evening Sir...
I have posted a reply for the explanations required by you to solve my problem.
Shall I expect a solution Sir....

I saw post #5 when it was originally added. If I could have helped, I would have done so then however I don't know how what you want could be done, perhaps someone else will.
I hope that you have a blessed day.