The code below inserts a formula into the given cell resulting in "=E18*$A$1" where "A1" = the cost of the customer, see attachment: Copy of Row Columns.xlsm
Is there a way to modify this section of the code only (see below) where the result of the cell will return "=E18*0.3"? Now obviously I can enter "0.3" into the macro but the value in A1 will always change with every invoice, so the code needs to be flexible.
Thanks in advancePlease Login or Register to view this content.
Bookmarks