Hi all,
I have the below quotation tool and in column O i have the line total with has the hidden formula: =M4*N4..
However i want to assign a Macro in -1%, so as to apply 1% discount in the each "line total" and then give the total. I also want to perform the same with 2% discount
I've a VBA code for inserting rows and keeping format & formulas. Would the discount vba code also work when I will insert rows?
Thanks in advance!!
I have the below quotation tool and in column O i have the line total with has the hidden formula: =M4*N4..
However i want to assign a Macro in -1%, so as to apply 1% discount in the each "line total" and then give the total. I also want to perform the same with 2% discount
I've a VBA code for inserting rows and keeping format & formulas. Would the discount vba code also work when I will insert rows?
Thanks in advance!!