Changing variable based on a count

Hi,

In the code below i am looping through a table finding the rows with particular code (product code) and performing math on another column on that row (units) and adding it to another sheet. The problem i am having is i want the variable 'e20' to be the multiplier 'e202' when a certain number in this case greater than 250 is met. The code below attempts that however if i break this threshold of 250 in the middle of a calculation it does not register that say half of the calculation needs to be at 'e20' and the other at 'e202'. Any advice would be great.

Thanks,
SPM

Please Login or Register  to view this content.

@ silkpantsman

In your code, on the line:

Please Login or Register  to view this content.

I assume that the first time the cell(16,3) was =0, and continue to perform the sum using e20.
For the second pass, Cells(16, 3)has a value different to 0, so the code skips to the next line:

Please Login or Register  to view this content.

If you had not reached to 250 in the first pass, the code stops.

Sometheing is wrong in your flow diagram for the code