Try this:

Select the Col_B range to be impacted
Press the [F5] key........a shortcut for <edit<go to
Click [Special].......Select: Blanks
Click [OK]

While the blank cells are selected...
Type: = then, Press the UP arrow
Hold down the [Ctrl] key and press [Enter]

Now every (formerly) blank cell references the cell above it.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

wrote in message
ps.com...
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