software

Can anyone help me he

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!

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 gt; Options gt; view tab gt; Uncheck quot;Zero valuesquot; gt; OK
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Toto Sandersonquot; gt; wrote in message
...
gt; Can anyone help me he
gt;
gt; How do I setup transfering data in a row to a column on another sheet so
gt; that when I input anything in the row, the column in the other sheet will
be
gt; automatically filled.
gt;
gt; I tried =Sheet1!A1 and then copy down. But the second cell down becomes
gt; =Sheet1!A2, whereas I want it to be =Sheet1!B1
gt;
gt; Thanks in advance!
Great! That's working perfectly! Thanks!!!!

quot;Maxquot; wrote:

gt; One way ..
gt;
gt; In Sheet2,
gt;
gt; Put in any starting cell, say, in B2:
gt; =OFFSET(Sheet1!$A$1,,ROW(A1)-1)
gt; Copy B2 down
gt;
gt; B2 returns the same as: =Sheet1!A1
gt; B3 returns: =Sheet1!B1
gt; B4 returns: =Sheet1!C1
gt; and so on ..
gt;
gt; And for a neat look, suppress the display of zeros in the sheet via:
gt; Click: Tools gt; Options gt; view tab gt; Uncheck quot;Zero valuesquot; gt; OK
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;Toto Sandersonquot; gt; wrote in message
gt; ...
gt; gt; Can anyone help me he
gt; gt;
gt; gt; How do I setup transfering data in a row to a column on another sheet so
gt; gt; that when I input anything in the row, the column in the other sheet will
gt; be
gt; gt; automatically filled.
gt; gt;
gt; gt; I tried =Sheet1!A1 and then copy down. But the second cell down becomes
gt; gt; =Sheet1!A2, whereas I want it to be =Sheet1!B1
gt; gt;
gt; gt; Thanks in advance!
gt;
gt;
gt;

Glad to hear that !
Thanks for feedback ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Toto Sandersonquot; gt; wrote in message
...
gt; Great! That's working perfectly! Thanks!!!!