I want to add amt col and do the calculation as amount=mrp-SchemeDiscAmt-LotDisc and also remove total row at the end

[aparna3010 (Aparna)]

akashdeep.xlsx (10.0 KB)

[NIVED_NAMBIAR (NIVED N)]

Hi @aparna3010
I tried with this way

Invoke code

Invoke code argumnets

dt1 is datatable obtained as result of read range (from A9)

after this it would write dt1 to same sheet from A9

Got results as

Regards,
Nived N
Happy Automation

[aparna3010 (Aparna)]

Thank you sooo Much!! It Means a lott to me!!Thanks a ton!!

[NIVED_NAMBIAR (NIVED N)]

Mark it as solution if this helps you around @aparna3010

[PraveenKumar]

attach the solution file too