Forum Discussion
Solved
How to fill multiple worksheets
Hi, sorry if this has been asked but I'm unable to find the answer. I have a sheet with my students information on it and I want to autofill each students information onto individual worksheets. How ...
- If I understand you correctly, then, you want to be able to print a copy for each student, a printed sheet that the parents can complete (and/or correct). Emphasis on PRINTED.
If that's in fact a correct understanding, your best way to create a really nice personalized printed sheet would be to use your Excel database (which is a good one) as the source for data in a MailMerge through Microsoft Word. That would give you the maximum amount of flexibility in formatting (including adding a nice graphic). The two packages (Excel and Word) are made to collaborate, and do so well, for exactly that kind of output.
https://www.webucator.com/article/how-to-use-mail-merge-in-microsoft-word-lnvonqmbps/
mathetes My reason for wanting each student to have their own worksheet is so that I can have their personal contact information preprinted for my records and parents wouldn't have to fill out a blank information form for me because as someone with 4 children, I know how tedious and time consuming it is every year. I would be able to have them check it for accuracy without exposing their information to other parents. I could just run the report the district gives us with their info on it, but being the weirdo I am I would like to have that info on my own, (cute?) form. I teach 2nd grade.
I've attached a pdf for reference. TIA
If I understand you correctly, then, you want to be able to print a copy for each student, a printed sheet that the parents can complete (and/or correct). Emphasis on PRINTED.
If that's in fact a correct understanding, your best way to create a really nice personalized printed sheet would be to use your Excel database (which is a good one) as the source for data in a MailMerge through Microsoft Word. That would give you the maximum amount of flexibility in formatting (including adding a nice graphic). The two packages (Excel and Word) are made to collaborate, and do so well, for exactly that kind of output.
https://www.webucator.com/article/how-to-use-mail-merge-in-microsoft-word-lnvonqmbps/
If that's in fact a correct understanding, your best way to create a really nice personalized printed sheet would be to use your Excel database (which is a good one) as the source for data in a MailMerge through Microsoft Word. That would give you the maximum amount of flexibility in formatting (including adding a nice graphic). The two packages (Excel and Word) are made to collaborate, and do so well, for exactly that kind of output.
https://www.webucator.com/article/how-to-use-mail-merge-in-microsoft-word-lnvonqmbps/