Copying Data Horizontally from Vertical List

[Guest]

On Sheet1 I have a Column of data, call it ColA.

On Sheet2 I'd like to transfer Sheet1!A1 to Sheet2!
A1...simple enough.

=Sheet1!A1 entered in Sheet2!A1

Now I'd like to copy/drag across Row1/Sheet2 such that
Sheet1!A2 goes into Sheet2!B1, Sheet1!A3 goes into
Sheet2!C1...etc.

I've tried dragging the above and also =Sheet1!$A1,
neither give me the desired results.

Is this impossible or what am I doint wrong?

 

[Jason Morin]

Try:

=OFFSET(Sheet1!$A$1,COLUMN()-1,)

HTH
Jason
Atlanta, GA

 

[Guest]

Thanks Jason for the quick comeback....works just like
need........