Thank you Jason...but what if I want to keep this worksheet as a template and
import other worksheets...I would have to do this each time instead of having
a template with formula's so that when I import it automatically did this
step for me??? does this make any sense?

Thanks again!

"Jason Morin" wrote:

One way:

1. Select the range in col. D.
2. Press F5 Special and click "Blanks". OK.
3. Press "=" and click on the cell to the immediate right
in col. E. of the first blank cell in col. D.
4. Press <Ctrl<Enter.

HTH
Jason
Atlanta, GA

-----Original Message-----
Cannot seem to get this to work...

If text in cells in column D are blank then copy text in
cells from column E
without overwriting any existing information in cells in
column D...

Does this make sense???? HELP!!!!! Looking at screen
too long!!!
.