For each & if question

[Crispy85]

Hi all,

I have this file with in Q and R amounts. Whenever there is amount in both that is not equal to 0 i want to copy the line and insert below.

Therefor i use this script:

Please Login or Register  to view this content.

It skips the ones that does not match the statement correctly. However, once it found an item that results in a TRUE it keeps repeating to copy and inserting the same item over and over again. Can someone see whats wrong with my code?

[LeoTaxi]

Hi,

what you have is a never ending loop, try like this

Please Login or Register  to view this content.

Kind regards
Leo

[Crispy85]

This works great Leo thanks.
Is there a way to include in your script that it copies the amount from R into column Q in the line item that was inserted?

[LeoTaxi]

the it looks like this

Please Login or Register  to view this content.

Kind regards
Leo

[Crispy85]

Hi Leo,

That's awesome, thanks!

Regards,
Crispy