Calculate total Amount

[sanju]

Hello friends,
I am trying to calculate total amount from Disbursed and Un-disbursed Amount.

Thank you

 

[NARAYANK991]

Hi ,

See if this is correct.

Narayan

 

[sanju]

Narayan,

Thank you very much, it is working very well.

 

[sanju]

sir,
I removed column D and placed it in column E, And put the totaling column in D. so Please give me new code.
sorry for my bad english
Thank you

 

[NARAYANK991]

Hi ,

See the attached file , and next time do not open duplicate threads.

Narayan

 

[sanju]

Thank you sir, is it possible for every sheet on single click.

 

[NARAYANK991]

Hi ,

See the attached file.

To run the macro , click the button with the symbol for pi , on the Quick Access Toolbar (QAT). The macro will run on which ever is the worksheet which is activated when the button is clicked.

I assume that all worksheets will have data in the same layout.

Narayan

 

[sanju]

Thank you sir, you great help