Automatically add a value in a column
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
|