Try this:

Select from the first category down through the last relevant blank cell

Press the [F5] key......a shortcut for <edit<goto
Click the [special cells] button
Check: Blanks
Click the [OK] button
(that will select all of the blank cells in that range)

WHILE THOSE CELLS ARE STILL SELECTED...
Type: =...to start building a formula
Press the UP arrow one time
Press CTRL + ENTER...to put that formula in each blank cell

Does that help?
Post back if you have more questions.
--------------------------

Regards,

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

Select the whole range of categories (hardcoded and formulas)
<edit<copy
<edit<paste special...Check: Values ...Click [OK]
"Cefoxtrot" wrote in message
...
Setting up a data entry screen with 9 columns. The first 3 columns (Entry
date, salesman, customer) might repeat several times: How do I repeat and
display the value from the cell above if there is no value entered in the
current cell?
Thank you!
Carl