Copying formulas between sheets

[chinley]

I'll try and explain this best I can.
I have one sheet with a list of around 1000 names in A1 to A1000. In the next sheet I want the same names to appear, by use of a formula, but in the columns A1 to AAA1 etc.
The way I'd usually do this when copying formulas is to use the dollar sign to lock either the row or column. But this doesn't work when switching from a list in rows to a list on columns.

Any help would be greatly appreciated.

 

[VoG]

In A1 of sheet2 enter

=INDEX(Sheet1!$A:$A,COLUMN())

and fill the formula to the right.

 

[chinley]

Thanks a lot