Thanks for responding. Your solution answered part of the question, but the
part that I can't figure out is this:

Once the value of 525 has been reached it enters a value of 2000. On the
next line it has to revert back to 0 until 700 has been reached where it
enters a value of 3000. On the next line it reverts back to 0 until 1050 has
been reached, etc.

In other words the column that enters the value 2000, 3000, etc. can only
enter that value once a certain objective has been met and can only enter
that value once.

example:

525 2000
600 0
650 0
700 3000
800 0
900 0
1000 0
1050 2000

thanks!
--
j