E
ElaineYKwan
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)
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)