I have a sheet with about 20 records. One column is for Company. However the
way the data was compiled only the first record has a value for company and
then there is no value again until the new company e.g

Name | Company

Jones | Acme
Smith |
Nadel |
Catn | WidgetInc
Mazuk |
Barny |
Jones | GNC
Walen |
Smith | CenterFilms
Balboa |

So far I've been doing keystroke combos to select next, select all down to
next, back up one, fill down. This takes a long time and is prone to error.

Is there some command/macro that would do this for me automatically?

Hi,

Select the cells in the column, starting in the row below the column heading.
Choose Edit | Go To
Click the Special button
Select Blanks, click OK
Type an equal sign
Press the up arrow on the keyboard -- this will enter a reference to the
cell above -- cell A2 in this example
Hold the Ctrl key and press Enter -- this enters the formula in all selected
cells




"msnyc07" wrote:

I have a sheet with about 20 records. One column is for Company. However the
way the data was compiled only the first record has a value for company and
then there is no value again until the new company e.g

Name | Company

Jones | Acme
Smith |
Nadel |
Catn | WidgetInc
Mazuk |
Barny |
Jones | GNC
Walen |
Smith | CenterFilms
Balboa |

So far I've been doing keystroke combos to select next, select all down to
next, back up one, fill down. This takes a long time and is prone to error.

Is there some command/macro that would do this for me automatically?

Dude, you ROCK! Saved me days. Thank you!

"Eduardo" wrote:

Hi,

Select the cells in the column, starting in the row below the column heading.
Choose Edit | Go To
Click the Special button
Select Blanks, click OK
Type an equal sign
Press the up arrow on the keyboard -- this will enter a reference to the
cell above -- cell A2 in this example
Hold the Ctrl key and press Enter -- this enters the formula in all selected
cells




"msnyc07" wrote:

I have a sheet with about 20 records. One column is for Company. However the
way the data was compiled only the first record has a value for company and
then there is no value again until the new company e.g

Name | Company

Jones | Acme
Smith |
Nadel |
Catn | WidgetInc
Mazuk |
Barny |
Jones | GNC
Walen |
Smith | CenterFilms
Balboa |

So far I've been doing keystroke combos to select next, select all down to
next, back up one, fill down. This takes a long time and is prone to error.

Is there some command/macro that would do this for me automatically?