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

akashdeep.xlsx (10.0 KB)

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

Nived N
Happy Automation


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

1 Like

Mark it as solution if this helps you around @aparna3010

1 Like

attach the solution file too :slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.