To clarify things, you want column be to be filled in correct? If column B
already has a value (such as the BBBBB and CCCCC in your example) you want
that to remain in column B, if the cell is blank in Column be you want to
fill it in with the AAAA from column A?

(also are the cell contents text? or numbers? perhaps some real examples of
what the data looks like would help.)

" wrote:

Hi All,

I have the following data.

Column A Column B
AAAAA BBBBBB
AAAAA
AAAAA
AAAAA
AAAAA CCCCCCCC
AAAAA
AAAAA
AAAAA

What i need to do is fill the blanks in column A when there is a value
to return.

i.e. every line cell in column B needs a value from above??

does that makes sense? i have been looking at this for 4 hours now and
don't konw myself what day it is!!! :(

thanks again.

Craig