Copy from worksheet if cell is blank

J

Jeff Gross

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top