Refering to Row Data in a Column

[Steve=True]

Hi All,

Thanks for your thoughts!

I have data that a user inputs in a row A3:Z3

I need to display this data in a Column on another worksheet: B2:B26

For instance, i have totals in a row and i want to display those values in a column on another worksheet.

Is there way to refer to this range in column format?

If you refer to A3 in a worksheet and copy down, it will copy the reference as A3:A26. But i want the reference to look at A3:Z26.

Anyway to do this with a formula?

I have been selecting the cells individually and thought there has to be a better way.

 

[Desu Nota from Columbus]

So you want [From a different sheet] A3:A26, B3:B26, C3:C26, ..., and Z3:Z26 to be in one column?

or A3, B4, C5, D6, ..., Z26?

 

[Andrew Poulsom]

Try a formula like this:

=INDEX(Sheet1!A$3:Z$3,ROW(A1)-ROW(A$1)+1)

Change the sheet reference to suit.

 

[Steve=True]

Awesome, works like a charm. Thanks. I knew there was a way to do it, but i couldn't wrap my head around it.

I really appreciate it.