help with my script to substract two values

[Crispy85]

Hello,

I'm calling out the guru's once again.
For a template i use the following script, provided by someone on the forum here
It works great and fast.

It checks if there are two values in one row in certain columns, and if so, it creates a duplicate row for one of these values.
In this case it should substract the value in column 14 with the value of column 13.

So in column 13 is 100 and column 14 is 1500
It creates a new row for the 1500 value, but it should substract it with 100.

Does anyone know how to fix this in this script?

Please Login or Register  to view this content.

thanks!!

[NeedForExcel]

Can you attach a sample workbook where I can run this code & test?

[Crispy85]

Hi NeedForExcel,

I cant simply do this because of company information.
However i just now solved this with substracting the values from eachother in case column 13 <> 0 before going into the for each.
So it is basically solved

Thanks anyways!

[NeedForExcel]

No problem..