autofill information from rows to columns without using transpose
 

Using Excel 2003

I have record information in rows in sheet 1. After using the "equals sign"
from each specific cell in a row 1 to a specific column(A) in sheet 2, I use
the auto fill to copy formulas accross the columns fo sheet 2. The result in
sheet 2, column B1 is starting with sheet 1 B1 instead of A2.

Any ideas?

Rayce

In A1 of Sheet2 enter this formula then drag across sheet2 row 1.

=OFFSET(Sheet1!$A$1,(ROW()-2)*1+COLUMN(),0)


Gord Dibben Excel MVP


On Sat, 3 Sep 2005 17:08:01 -0700, "Rayce"
wrote:

Using Excel 2003

I have record information in rows in sheet 1. After using the "equals sign"
from each specific cell in a row 1 to a specific column(A) in sheet 2, I use
the auto fill to copy formulas accross the columns fo sheet 2. The result in
sheet 2, column B1 is starting with sheet 1 B1 instead of A2.

Any ideas?