filling in blank rows by the next available filled row

[debayan]

Ok,

I am at my wits end. Multiple problems in my sheet. First I will paste my code. The excel sheet is also added as an attachment.

Please Login or Register  to view this content.

Problem 1:- I am trying to program the following condition. Pls refer excel sheet.Sheet1
=if(A4="",A3,A4) and loop it till the value in cell I1. On executing the above code, it only returns the value as 1 which means only the if condition is executed. The else condition never gets activated at the first point (cell A67 in this sheet) where it should be activated.

Problem 2:- The "for i = " command is not running properly, although it runs properly when I put in actual numeric values like 4 to 768 (which is my count in cell I1), is there a error in syntax.

Problem 3:- I am also trying to program the following condition =value(left(B4,$G$1)) and loop it till the value in cell I1. But have no clue as to what the syntax will be.

Please, i know its rather long, but help me out on this

Reagrds,
Debayan

[StephenR]

Your loop goes from 4 to 3, hence it doesn't work! Can you explain in plain English what you are trying to do?