Perhaps you could explain exactly what you want to do, and give
details like the sheet names involved, the cells you want to work with
and the formula you are using now.

Pete

On May 21, 7:55*pm, robeck wrote:
Do I need to write something in Visual Basic? *I have done some macros but
haven't done anything conditional with a macro, is there a way to do that?



"Pete_UK" wrote:
A formula cannot move or copy a cell, so you would need a macro to do
what you want to achieve.

Pete

On May 21, 4:34 pm, robeck wrote:
I am using vlookup to interrogate a column of cells and if the value I input
is not found in the column I would like to move the input value to the 1st
open cell at the end of the column. *I don't know how to determine what the
1st open cell is without having to list each cell and check if it is blank.. *
Is there a way to look for the first cell that is blank? Thanks.- Hide quoted text -

- Show quoted text -