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

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

Thanks Ron, that seems to work after the fact... it fills all blank cells
correctly. My goal is to do it as data entry takes place, i.e. : if nothing
is entered at cell d14, it should default and print the content of d13. Is
that possible?
Carl

"Ron Coderre" wrote:

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

You'd need a VBA program to effect the activity you're describing.

If it would be the only code in the workbook and it's not critical,
it may not be worth the trouble of possibly changing everyone's
security settings, editing the trusted site list, and getting prompted
to enable macros whenever the workbook is opened

Your call...

--------------------------

Regards,

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

"Cefoxtrot" wrote in message
...
Thanks Ron, that seems to work after the fact... it fills all blank cells
correctly. My goal is to do it as data entry takes place, i.e. : if
nothing
is entered at cell d14, it should default and print the content of d13. Is
that possible?
Carl

"Ron Coderre" wrote:

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

If you are going to do this during data entry just press Ctrl-D and it will
copy whatever is in the cell above including fomatting.


"Cefoxtrot" wrote:

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