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 brings in all the correct data for each field. My question is how can I make excel print the the entire data sheet by row individually without having to type badge numbers individually and to then print?
You might use mail merge in Word with the Excel sheet as data source.
13 Replies
- HansVogelaar you’re amazing! You didn’t give up on me and understood exactly what I needed. The spreadsheet you helped me create is going to make my job so much easier. You are the TRUE meaning of an MVP! You’re kindhearted and overall patient. Again, thank you from the bottom of my heart! I promise to cherish my spread sheet forever.
God Bless you!
Thank you!
Ldelgado3914 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.
