I have a cash flow that is modeled out monthly (the months are columns) over 5 years. The top line of my sources section is for owner contributions. The contributions are dependent upon the previous month's net and cumulative cash flow as well as the current month's excess or shortage in cash. I need to perform a series of logic statements on every column to determine if money should be added to the company. However, the previous month has to have a zero net cash flow before the current month's contributions can be calculated. In short, I need a macro that will perform logic statements one column at a time for 60 columns.

Any suggestions would be greatly appreciated.

Thanks