I have a spread sheet that is broken into two sections, the first section requires some input in certain columns then the other columns have formauls that work off the information keyed into the first five columns.
The second part of the spread sheet is all hand entered.
There is a blank row that seperates the two sections.
I need a macro that will look at column "C" starting a row "12" and if the cell is populated to insert a formula into column "I" until it comes to the blank row then it should stop as the second half of the spread sheet is hand entered and no formulas are needed.
Thanks
Mark
The second part of the spread sheet is all hand entered.
There is a blank row that seperates the two sections.
I need a macro that will look at column "C" starting a row "12" and if the cell is populated to insert a formula into column "I" until it comes to the blank row then it should stop as the second half of the spread sheet is hand entered and no formulas are needed.
Thanks
Mark