Filling cells vertically with data from cells arranged horizontally

I have 350 horizontal cells with data.
I want to reference these cells in a vertical column on anther sheet.
How do I write the first one and then drag down and have the correct reference automatically, so I don't have to type into Sheet 2 each cell from Sheet 1 by hand?


Example:
Sheet1

A1 B1 C1 D1 E1..... ...ML1 MM1 MN1
Bob Sally Fred Sam Susan Jill Joe John




Sheet2

A1: =SHEET1!A1
A2: =SHEET1!B1
A3: =SHEET1!C1
A4: =SHEET1!D1
A5: =SHEET1!E1
...
A348: =SHEET1!ML1
A349: =SHEET1!MM1
A350: =SHEET1!MN1




Thank you very much.

Thanks. How do I do this??

I will try this. Thank you.

Okay, I think I oversimplified my example and now I can't figure out how to translate it!

My actual "Sheet1" is actually called "Sorter", and my first cell across starts at C8.
My actual "Sheet2" is actually called "Bank Data", and my first down cell starts at K10.

Could you show me how to do it for these?

Thank you very much.

Hi..

Maybe this..?

Please Login or Register  to view this content.

Originally Posted by alansidman

Which thread are you referring to? If mine, then look at this link

http://www.techrepublic.com/blog/mic...or-vice-versa/

This ended up doing the trick. Thanks very much.