Extracting or exporting Data From Excel Individual ROW Directly to INDIVIDUAL page in word

I have a long list of employees with emp name , emp code, department and mobile number in EXCEL. I have to export every single employess detail to separate page in word and take a print out of all pages. Please help me on this


Example:

SL EMPLOYEE CODE NAME DESIGNATION DEPARTMENT
1 a x y z
2 b p q r


then in word it should be displayed as
(Page 1)
Sl -1 emp code-a name-x desig-b dept-z

(Page 2)
Sl-2 emp code-b name-p desig-q dept-r


please help me on this

I am a canteen manager, so for calculation of breakfast lunch and dinner i have a format of 30 days in which employess do their signature and take the food. So, for that i need it.

This is something i found somewhere. Can anyone please tell how and where to use this code. I am totally a new bee in this

Try this. Test with very small sections to start with if you are actually using paper.
Better if you can set to print to a pdf printer if you can for testing.

1. Set your 'Rows to Repeat at Top' manually in Page Setup as usual (say rows 1-5).

2. Select the group of rows you want to print (including disjoint rows if you want). This is just the student rows, not the heading rows.

3. Run the macro below.


Sub PrintSelectionOneLinePerPage()
Dim c As Range

ActiveSheet.ResetAllPageBreaks
For Each c In Intersect(Selection.EntireRow, Columns("A"))
ActiveSheet.HPageBreaks.Add c.Offset(1)
Next c
Selection.PrintOut
ActiveSheet.ResetAllPageBreaks
End Sub