software

I am pulling info from one sheet to another. I need to copy a formula going
vertically down, but I need the column designator to ascend and not the row.Hi Ken

One way
Supposing you have data in cells A1:E1 on Sheet2 and you want to copy
the data to cells A1:A5 of Sheet1
In cell A1 of Sheet1
=OFFSET(Sheet2!$A$1,0,ROW(1:1)-1)
and copy down.

--
Regards

Roger Govierquot;Ken Proj mgrquot; gt; wrote in message
...
gt;I am pulling info from one sheet to another. I need to copy a formula
gt;going
gt; vertically down, but I need the column designator to ascend and not
gt; the row.
gt;

Just to clarify what you are looking for: You are looking to have a
formula that in
Row 1 =Sheet2!A1
Row 2 =Sheet2!B1
Row 3 =Sheet2!C1--
kraljb
------------------------------------------------------------------------
kraljb's Profile: www.excelforum.com/member.php...foamp;userid=9955
View this thread: www.excelforum.com/showthread...hreadid=516282Yes. I am putting the info into a column and I am pulling it from a row.

Ken

quot;kraljbquot; wrote:

gt;
gt; Just to clarify what you are looking for: You are looking to have a
gt; formula that in
gt; Row 1 =Sheet2!A1
gt; Row 2 =Sheet2!B1
gt; Row 3 =Sheet2!C1
gt;
gt;
gt; --
gt; kraljb
gt; ------------------------------------------------------------------------
gt; kraljb's Profile: www.excelforum.com/member.php...foamp;userid=9955
gt; View this thread: www.excelforum.com/showthread...hreadid=516282
gt;
gt;

Roger,
I got it to work. Thanks for the help. I am preping 70 schedule sheets for
various sub to build homes and this formula will save me a week worth of
typing. You sir are the man.

Ken

quot;Roger Govierquot; wrote:

gt; Hi Ken
gt;
gt; One way
gt; Supposing you have data in cells A1:E1 on Sheet2 and you want to copy
gt; the data to cells A1:A5 of Sheet1
gt; In cell A1 of Sheet1
gt; =OFFSET(Sheet2!$A$1,0,ROW(1:1)-1)
gt; and copy down.
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Ken Proj mgrquot; gt; wrote in message
gt; ...
gt; gt;I am pulling info from one sheet to another. I need to copy a formula
gt; gt;going
gt; gt; vertically down, but I need the column designator to ascend and not
gt; gt; the row.
gt; gt;
gt;
gt;
gt;