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.