$$Excel-Macros$$ Appropriate formula required

Dear Friends, In the attached list the total monthly allocations is more than the total amount to be allocated, please suggest a suitable formula to compute the same. R'gds Dhanesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ Fixing the problem

Dear Friends, I want to put a formula in the attached sheet to calculate automatically as and when I change the periods., please help.. Rgds Dhanesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help