Copy from worksheet if cell is blank
 

Hi-

I have 300 rows of data possible on sheet2 (variable). Column A on sheet2
is currently blank. The data starts in column B of sheet and is the result
of an "IF, Then" formula.

What I need the code to do is starting with A2, look for data in B2 and if
the result of the IF/Then statement in B2 results in a blank cell, go to the
next row and repeat for row 3. If there is data in B2, copy a cell from a
different worksheet into this cell and then continue on to row 3.

Thanks, Jeff.