Forum Discussion
Solved
Excel to print individual pages by rows
I have an excel template along with an excel data sheet within the same workbook. I have successfully assigned the cell values into the template. When I put in a badge number on the template it bring...
You might use mail merge in Word with the Excel sheet as data source.
You might use mail merge in Word with the Excel sheet as data source.
- Thank you for your reply. The data needed will not fit on a word document accurately due to the needed width of each column. 😔
Apparently I don't understand what you want, sorry. Could you describe it in more detail.
- I have prepared an excel template for open enrollment. The data sheet contains employees badge numbers and their current coverages.
I have assigned the cells needed on the enrollment form template.
When I put the badge number on the enrollment form the data pulls from my data sheet correctly.
What I'm trying to accomplish is to print all 50 employees enrolment forms as a workbook instead of having to enter every employees badge number and printing the forms individually.
