autofill information from rows to columns without using transpose

[Guest]

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?

 

[Gord Dibben]

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