ExcelBanter - "Cross"-Auto filling: consecutive columns into rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - "Cross"-Auto filling: consecutive columns into rows (https://www.excelbanter.com/excel-worksheet-functions/245874-cross-auto-filling-consecutive-columns-into-rows.html)

AndreasW

"Cross"-Auto filling: consecutive columns into rows

How can I auto fill a column with a formula referencing to consecutive
columns in another sheet?
Example:
A
1 =OtherSheet!A1
2 =OtherSheet!B1
3 =OtherSheet!C1
....

Jacob Skaria

"Cross"-Auto filling: consecutive columns into rows

=INDEX(Sheet1!$1:$1,ROW(A1))
and copy down..for getting the values from sheet1 row 1

If this post helps click Yes
---------------
Jacob Skaria

"AndreasW" wrote:

How can I auto fill a column with a formula referencing to consecutive
columns in another sheet?
Example:
A
1 =OtherSheet!A1
2 =OtherSheet!B1
3 =OtherSheet!C1
...

All times are GMT +1. The time now is 07:11 PM.