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