Thank you Dave, the link to the website was exactly what I needed.

"Dave Peterson" wrote:

=if(a1="","",a1)
(in A2)

If you're trying to fill a bunch of cells with the value from the above cells,
you may want to take a look at Debra Dalgleish's site:

http://contextures.com/xlDataEntry02.html

She has some manual ways (very quick though) and some code, too.

Jacky D. wrote:

How can I get a column to test if there is text in a row above when there is
an empty cell, and then copy the text from the row above into the empty cell
automaticlly?
Thanks,
Jacky D.

--

Dave Peterson