nivesh870330
New Member
- Joined
- Aug 21, 2014
- Messages
- 2
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.
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.

Sheet 2:
![URL]](/board/proxy.php?image=http%3A%2F%2F%5BURL%3D%22http%3A%2F%2Fpostimg.org%2Fimage%2F6wsrl9nb9%2F%22%5D%5Bimg%3Dhttp%3A%2F%2Fs2.postimg.org%2F6wsrl9nb9%2FSheet_2.jpg%5D%5B%2FURL%5D&hash=777ceae349c5af9cf849529250a436ef)
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.