Copying data from 1 sheet to another with variable row intervals

[ExcelTeacher]

Hi there,
Here's the challenge I am facing.
I have data on one sheet and I am trying to fill a form I have made in Excel on another sheet.
I am trying to copy data from A1 (1st sheet) to C1 (2nd sheet) then I skip a few rows to insert the next row :
A2 (1st sheet) to C8 (2nd sheet).
What formula do I use when I paste formulas while skipping rows?

 

[dermie_72]

Just so I understand you correctly. you want.
Sheet1 Sheet2
A1 C1
A2 C8

is the gap between the two always the same? as in will the next on be:
A3 C15

If not, what is the variable that determines which row in sheet 2 you're placing the next A data?

 

[ExcelTeacher]

Just so I understand you correctly. you want.
Sheet1 Sheet2
A1 C1
A2 C8

is the gap between the two always the same? as in will the next on be:
A3 C15

If not, what is the variable that determines which row in sheet 2 you're placing the next A data?

Yes the gap will always be the same

 

[Drrellik]

A quick look at the range from C1,C8,C15 takes you to C92 by the 14th paste and to 99 on the 15th. how compact/long is sheet 2 that being said you can do this if you want. go to sheet2 cell C1 and type Sheet1!A1 (do not put the =) in the cell just the text. then do the same for C8 & C15 changing the A1 to A2 & A3. then select cell C2-C15 and drag it down as far as you need to filling the other 22,29,36,.... and so on with the value Sheet1!A.. once you have all your cells filled open the find and replace window with the CTRL+H in the find type SHE in the replace type =SHE and hit replace all.

Thats how I would do it. now this means you have no data in C2,3,4,5,6,7, C9,10... and so on because you are making them blank. HTH Don

 

[caabyyc]

In C1 of sheet2, type "=IF(MOD(ROW(A1),7)<>1,"",INDEX(Sheet1!A:A,MOD(ROW(A1),7)+INT(ROW(A1)/7)))", then drag it down.

 

[ExcelTeacher]

I tried all of that and it doesn't seem to work.

Here are my exact parameters, maybe it will help.

On Sheet 2
Every row has data per student (courses, teachers, course data, etc.)

On Sheet 3
I made a template of the report I want to print out (2 reports per page)
This is what I want on the report.
Report 1
Sheet 3 A1 (data from Sheet 2 G2)
Sheet 3 F1 (data form Sheet 2 D2)
Sheet 3 B3 (data form Sheet 2 J2)
Sheet 3 C3 (data form Sheet 2 M2)
Sheet 3 E3 (data form Sheet 2 P2)
Sheet 3 F3 (data form Sheet 2 S2)
Sheet 3 G3 (data form Sheet 2 V2)
Sheet 3 B4 (data form Sheet 2 K2)
Sheet 3 C4 (data form Sheet 2 N2)
Sheet 3 E4 (data form Sheet 2 Q2)
Sheet 3 F4 (data form Sheet 2 T2)
Sheet 3 G4 (data form Sheet 2 W2)
Sheet 3 A8 (data form Sheet 2 AI2)
Sheet 3 E8 (data form Sheet 2 AJ2)

Report 2
Sheet 3 A33 (data from Sheet 2 G3)
Sheet 3 F33 (data form Sheet 2 D3)
Sheet 3 B3 (data form Sheet 2 J3)
Sheet 3 C36 (data form Sheet 2 M3)
Sheet 3 E36 (data form Sheet 2 P3)
Sheet 3 F36 (data form Sheet 2 S3)
Sheet 3 G36 (data form Sheet 2 V3)
Sheet 3 B37 (data form Sheet 2 K3)
Sheet 3 C37 (data form Sheet 2 N3)
Sheet 3 E37 (data form Sheet 2 Q3)
Sheet 3 F37 (data form Sheet 2 T3)
Sheet 3 G37 (data form Sheet 2 W3)
Sheet 3 A40 (data form Sheet 2 AI3)
Sheet 3 E40 (data form Sheet 2 AJ3)

 

[Drrellik]

Good Morning, well these new parameters are quite a it different from your first post. how many additional sheets do you have. if it is just the 3 sheets you posted you could have finished by now just manually typing in =sheet#!(Cell) in each one and saving it.

 

[ExcelTeacher]

Sorry about that. I was trying to simplify things.

I have 3 sheets (Sheet 1 has raw data, Sheet 2 has the data organized per student, Sheet 3 will be the reports)
I have 248 reports to produce with the data from the students.