Data from consecutive rows to alternative rows within multiple spreadsheets

[nivesh870330]

Hi,

I have multiple same templates on my sheet 1 of excel file which has to be filled with data from sheet 2.
The problem is the data is sheet 2 are placed in consecutive rows.

The usual copy paste is not working.

Can someone help.

[/IMG]

Sheet 2:

Sheet 1:
http://i59.tinypic.com/2ebx3wl.jpg

Sheet 2:


How do i automate sheet 1 in such a way that when i copy paste A1 to B5 in A6 to B10 , i will get details of student 2 instead of student 5 from Sheet 2.

Please help.

 

[Special-K99]

I'm at work and can't read most of those images.
It's better to post a non data-sensitive spreadsheet or we have to type in your test data all over again which a lot of us won't do.

Prob some VBA solution would solve this.

 

[nivesh870330]

Its non data sensitive spread sheet only, you can take assume/anydata and tell me how its done.
The images are posted only as schematic, references

thanks and regards
nivesh

 

[Special-K99]

Again, I cant read the images