How do I set up a copy and paste formula with ascending columns

G

Guest

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.
 
R

Roger Govier

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.
 
K

kraljb

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Copy columns and paste with blank column between 5
Delete two columns with formula 2
I am having trouble with excel not ascending correctly 4
Formula Help 1
Copy formula 3
Finding a Value Between Two Numbers and Returning Corresponding Value 10
Countif with indirect formulas needed 0

Top