hello

im a bit stuck on how to write a macro that can stop a calculation for
the next date once its past a stop date. Example:

stop date: 03-JAN-2007

ive already written an IF statement that calculates the next due date
based on the iterations but wihtout a macro it requires me to visually
inspect my
data when I fill in the entire row, column by column until when its
hits my stop date.
i have about 100 rows with different starting due dates and different
iterations.
The macro need to know when to finish a row (when it hits/goes over the
given
stop date) and then move to the next row and do that same.

Every Unit Due Date Next due Date Next Due Date ...
7 days 22-Dec-06 29-Dec-06 Stop, next column
30 days 10-Dec-06 Macro Stops here, goes to next column
......

can anyone help? =o)