Autofill: Change direction

**adonis85** · 09-06-2008, 08:17 PM

Hello everybody,

Thanks for taking my question.

I would like to autofill the following(either by using the autofill function or whatever other kind of solution):

=RIGHT(Tabelle2!A$4;LEN(Tabelle2!A$4)-FIND(":";Tabelle2!A$4)-1)

in a way that the column changes

the result should look like this:

=RIGHT(Tabelle2!A$4;LEN(Tabelle2!A$4)-FIND(":";Tabelle2!A$4)-1)
=RIGHT(Tabelle2!B$4;LEN(Tabelle2!B$4)-FIND(":";Tabelle2!B$4)-1)
=RIGHT(Tabelle2!C$4;LEN(Tabelle2!C$4)-FIND(":";Tabelle2!C$4)-1)
.
.
.

Yet, since I'm autofilling downwards (the formulas are in one column), it won't change anything. The number is not changing for the dollar signs - and this is okay. What I would like to change is the columns' reference.

Is there any possibility to do this?

Thanks for helping,

Cheers,
Andy

**olasa** · 09-07-2008, 06:27 AM

If I understand correctly, as the formula is Copied down, column reference should increase.
In that case, use something like this:
=OFFSET(Tabelle2!A$4;0;ROWS(Tabelle2!$A$1:A1)-1)

Hope this helped
Ola