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