I
Intrepid_firefighter
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
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