how to setup transferring data from row to column

[Toto Sanderson]

Can anyone help me here:

How do I setup transfering data in a row to a column on another sheet so
that when I input anything in the row, the column in the other sheet will be
automatically filled.

I tried =Sheet1!A1 and then copy down. But the second cell down becomes
=Sheet1!A2, whereas I want it to be =Sheet1!B1

Thanks in advance!

 

[Max]

One way ..

In Sheet2,

Put in any starting cell, say, in B2:
=OFFSET(Sheet1!$A$1,,ROW(A1)-1)
Copy B2 down

B2 returns the same as: =Sheet1!A1
B3 returns: =Sheet1!B1
B4 returns: =Sheet1!C1
and so on ..

And for a neat look, suppress the display of zeros in the sheet via:
Click: Tools > Options > view tab > Uncheck "Zero values" > OK

 

[Toto Sanderson]

Great! That's working perfectly! Thanks!!!!

One way ..

In Sheet2,

Put in any starting cell, say, in B2:
=OFFSET(Sheet1!$A$1,,ROW(A1)-1)
Copy B2 down

B2 returns the same as: =Sheet1!A1
B3 returns: =Sheet1!B1
B4 returns: =Sheet1!C1
and so on ..

And for a neat look, suppress the display of zeros in the sheet via:
Click: Tools > Options > view tab > Uncheck "Zero values" > OK

 

[Max]

Glad to hear that !
Thanks for feedback ..