"Cross"-Auto filling: consecutive columns into rows

A

AndreasW

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

Jacob Skaria

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


If this post helps click Yes
 

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

Copy addition formula of non-consecutive horizontal cells 2
Comparing two spreadsheets part 2 10
Row reference for consecutive series calculation 0
Nameing a function 1
Referencing cells in consecutive rows 2
VBA Coding Help for Beginner 0
Auto populate value from one task to another in MS PROJECT 0
compare same data in two workbooks 5

Top