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 1:[/IMG]

Sheet 2:
[IMG][img=http://s2.postimg.org/6wsrl9nb9/Sheet_2.jpg][/IMG]


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

Sheet 2:
Sheet 1.jpg

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.Sheet 2.jpg