Hi,
Currently, i have written a macro that will select a new sheet based on
certain criteria in specific cells. i.e. if B4 contains "text" then move to
the next sheet until it finds "Complete". this is then your next sheet to
use. i now need to create something very similar but everything is to stay on
1 sheet so it need to look at the cells. If the cell contains anything, i
need to select the cell underneath which is empty. Or keep looking down a
column of cells until it finds an empty one. i hope this is understandable!

example:
range is B4 to B25. ( i need to update this column every day)
B4 contains data
B5 contains data
B6 contains nothing
therfore when i issue my macro, it will look at the B column and
automatically select the cell B6 as it contains nothing.

Is this acheivable??

Kind Regards,


Nigel