| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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 .... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"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 ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I auto transform sets of data? (change "female" to "f") | Excel Discussion (Misc queries) | |||
| text string: "91E10" in csv file auto converts to: "9.10E+11" | Excel Discussion (Misc queries) | |||
| Possible to "rotate" range of cells so columns are rows and vice versa? | New Users to Excel | |||
| Filling cells with absolute columns but "nth" rows | Excel Worksheet Functions | |||
| auto filling columns from rows | Excel Discussion (Misc queries) | |||
Hybrid Mode
