I have several big sheets and wants to add automatically a value to the cell
if the neighbourcell has a value.

Example:

A B C D
1 Ohio Mike 78 Man
2 Mona 34 Woman
3 John 43 Man
4 Linn
5 Lisa 44
6
7

This table should automatically - without knowing how many rows that
contains information - be like this:

A B C D
1 Ohio Mike 78 Man
2 Ohio Mona 34 Woman
3 Ohio John 43 Man
4 Ohio Linn
5 Ohio Lisa 44
6
7

Kjell

use helping column E

in cell E2 put this formula

=IF(B2="","",IF(A2="",E1,A2))





On Jan 11, 2:24*pm, "Obonden" <kjeblo(æt)frisurf.no wrote:
I have several big sheets and wants to add automatically a value to the cell
if the neighbourcell has a value.

Example:

* * * A * * * *B * * * * C * * * *D
1 * Ohio * Mike * * 78 * * Man
2 * * * * * * Mona * *34 * * Woman
3 * * * * * * John * * *43 * * Man
4 * * * * * * Linn
5 * * * * * * Lisa * * * 44
6
7

This table should automatically - without knowing how many rows that
contains information - be like this:

* * * A * * * *B * * * * C * * * *D
1 * Ohio * Mike * * 78 * * Man
2 * Ohio * Mona * *34 * * Woman
3 * Ohio * *John * * *43 * * Man
4 * Ohio * *Linn
5 * Ohio * *Lisa * * * 44
6
7

Kjell

Thanks, but that solution means I have to copy that formula to all cells
down to the last row containing data? How do I copy this formula without
knowing/seeing the data - I want to put this "auto-fill-in-routine" in a
macro. My problem is how to fill (a known) text into column A all the way
down to the last row without knowing how many rows there are in the sheet.

Kjell

"muddan madhu" skrev i melding
...
use helping column E

in cell E2 put this formula

=IF(B2="","",IF(A2="",E1,A2))





On Jan 11, 2:24 pm, "Obonden" <kjeblo(æt)frisurf.no wrote:
I have several big sheets and wants to add automatically a value to the
cell
if the neighbourcell has a value.

Example:

A B C D
1 Ohio Mike 78 Man
2 Mona 34 Woman
3 John 43 Man
4 Linn
5 Lisa 44
6
7

This table should automatically - without knowing how many rows that
contains information - be like this:

A B C D
1 Ohio Mike 78 Man
2 Ohio Mona 34 Woman
3 Ohio John 43 Man
4 Ohio Linn
5 Ohio Lisa 44
6
7

Kjell

Double-click on the fill handle in the bottom right-hand corner of the cell,
and it will automatically fill down as far as there is data in the adjacent
column.
--
David Biddulph

Obonden wrote:
Thanks, but that solution means I have to copy that formula to all
cells down to the last row containing data? How do I copy this
formula without knowing/seeing the data - I want to put this
"auto-fill-in-routine" in a macro. My problem is how to fill (a
known) text into column A all the way down to the last row without
knowing how many rows there are in the sheet.
Kjell

"muddan madhu" skrev i melding
...
use helping column E

in cell E2 put this formula

=IF(B2="","",IF(A2="",E1,A2))





On Jan 11, 2:24 pm, "Obonden" <kjeblo(æt)frisurf.no wrote:
I have several big sheets and wants to add automatically a value to
the cell
if the neighbourcell has a value.

Example:

A B C D
1 Ohio Mike 78 Man
2 Mona 34 Woman
3 John 43 Man
4 Linn
5 Lisa 44
6
7

This table should automatically - without knowing how many rows that
contains information - be like this:

A B C D
1 Ohio Mike 78 Man
2 Ohio Mona 34 Woman
3 Ohio John 43 Man
4 Ohio Linn
5 Ohio Lisa 44
6
7

Kjell

I knew it was difficult :-)
Thanks a lot!

Kjell


"David Biddulph" <groups [at] biddulph.org.uk skrev i melding
...
Double-click on the fill handle in the bottom right-hand corner of the
cell, and it will automatically fill down as far as there is data in the
adjacent column.
--
David Biddulph

Obonden wrote:
Thanks, but that solution means I have to copy that formula to all
cells down to the last row containing data? How do I copy this
formula without knowing/seeing the data - I want to put this
"auto-fill-in-routine" in a macro. My problem is how to fill (a
known) text into column A all the way down to the last row without
knowing how many rows there are in the sheet.
Kjell

"muddan madhu" skrev i melding
...
use helping column E

in cell E2 put this formula

=IF(B2="","",IF(A2="",E1,A2))





On Jan 11, 2:24 pm, "Obonden" <kjeblo(æt)frisurf.no wrote:
I have several big sheets and wants to add automatically a value to
the cell
if the neighbourcell has a value.

Example:

A B C D
1 Ohio Mike 78 Man
2 Mona 34 Woman
3 John 43 Man
4 Linn
5 Lisa 44
6
7

This table should automatically - without knowing how many rows that
contains information - be like this:

A B C D
1 Ohio Mike 78 Man
2 Ohio Mona 34 Woman
3 Ohio John 43 Man
4 Ohio Linn
5 Ohio Lisa 44
6
7

Kjell