How do I move data from one worksheet to another?

[Guest]

I have a spreadsheet that contains data (500 rows x 15 columns). I need to
move the data from each row to various cells on another worksheet.
I understand I can simple do an equals command such as =IF('List 2006 -
2007'!$F3=""," ",'List 2006 - 2007'!$F3), but the cells are not in the same
order on the second worksheet, so I was looking down the barrel of 7500
seperate formulars.
eg.
sheet 1 a1 = sheet 2 a1
sheet 1 b1 = sheet 2 a2
sheet 1 c1 = sheet 2 a3
......
sheet 1 n1 = sheet 2 a15

sheet 1 a2 = sheet 2 a21
sheet 1 b2 = sheet 2 a22
sheet 1 c2 = sheet 2 a23
......
sheet 1 n2 = sheet 2 a35

I'm sure there is a easy way to copy the formular with the correct
increments to save all that work. I'm also new to Excel (if you haven't
already worked that out), and would appreciate some help.
Regards

 

[Dav]

try the following

=IF(MOD(ROW(A34),20)<=14,OFFSET(Sheet1!$A$1,TRUNC(ROW(A34)/20),MOD(ROW(Sheet2!A34)-1,20)),"")

n is the 14th column hence <15 although you said it is 15 in your
example, if so change the formula but you mean o!

the forumula should go in cell A1

It moves across one column for every row you go down, but then goes
down on sheet1 at every multiple of 20 to get to the next row and
resets to the first column at the same time. it also puts ablank to the
rows that are gaps inbetween

regards

Dav