• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiply Columns VBA formula & trigger

Mukhtar

New Member
Dear Forum Members,

I am not so good at VBA, I need help.
I have upload an excel file and everything in explained on sheet 4. After getting answer from you, I have again to re-paste it in sheet 4, therefore the reference in formula should be to Sheet 4. It is a Loan sheet.

Regards,
Mukhtar
 

Attachments

  • Loan.xlsm
    14.5 KB · Views: 6
Hi,​
a code here is useless just using an Excel feature : a table !​
Once the range is defined as an Excel table and formulas within the first data row,​
the formulas are added when a new row is created within the table …​
 
Back
Top