Repeat value from cell above

[Cefoxtrot]

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

 

[Ron Coderre]

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]

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

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]

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

 

[Ron Coderre]

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)

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

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]

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

 

[Kruppy]

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.