SOLVED

How to fill multiple worksheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2581280%22%20slang%3D%22en-US%22%3EHow%20to%20fill%20multiple%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2581280%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20sorry%20if%20this%20has%20been%20asked%20but%20I'm%20unable%20to%20find%20the%20answer.%20I%20have%20a%20sheet%20with%20my%20students%20information%20on%20it%20and%20I%20want%20to%20autofill%20each%20students%20information%20onto%20individual%20worksheets.%20How%20do%20I%20tell%20excel%20that%20student%20'x'%20name%20from%20cell%20A2%20should%20go%20into%20cell%20B3%20in%20worksheet%20Student%20(1)%20and%20student%20'x'%20name%20from%20cell%20A3%20should%20go%20into%20cell%20B3%20in%20worksheet%20Student%20(2)%3F%3F%3F%20And%20I%20should%20warn%20you%20that%20you%20may%20have%20to%20use%20crayons%20to%20explain%20this%20to%20me%20because%20I%20am%20an%20excel%20novice.%20TIA.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2581280%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2581993%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20fill%20multiple%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2581993%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111272%22%20target%3D%22_blank%22%3E%40adevaughn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20often%2C%20in%20Excel%2C%20many%20ways%20to%20accomplish%20a%20given%20objective.%20In%20your%20case%2C%20it%20might%20be%20helpful%20if%20you%20gave%20us%20a%20bit%20more%20of%20the%20complete%20picture.%20What's%20the%20nature%20of%20the%20data%20you%20expect%20to%20have%20on%20each%20student%2C%20for%20example%2C%20and%20why%20do%20you%20want%20to%20have%20a%20separate%20spreadsheet%20on%20each%20student%3F%20I%20can%20understand%20having%20the%20ability%20to%20print%20out%20a%20full%20report%20on%20a%20single%20student%2C%20but%20that%20doesn't%20necessarily%20mean%20that%20each%20student%20needs%20to%20have%20her%20or%20his%20separate%20and%20permanent%20spreadsheet.%20It's%20fairly%20easy%20to%20extract%20data%20from%20a%20master%20database%2C%20a%20database%20containing%20all%20relevant%20into%20on%20ALL%20the%20students%20to%20report%2C%20one-by-one%20on%20each%20individual.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20if%20you%20could%20provide%20a%20more%20complete%20picture%20of%20what%20you're%20doing%20here%2C%20making%20sure%20you're%20not%20making%20assumptions%20based%2C%20say%2C%20on%20prior%20paper%20methods%20of%20tracking%20all%20this.%20Excel%20has%20remarkable%20abilities%20to%20manage%20data%2C%20and%20a%20common%20newbie%20mistake%20is%20to%20picture%20it%20as%20mainly%20a%20bit%20more%20automated%20but%20basically%20still%20a%20replica%20of%20prior%20paper%20records%20with%20you%20doing%20a%20lot%20of%20the%20%22heavy%20lifting.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20it's%20possible%2C%20could%20you%20post%20a%20copy%20of%20whatever%20spreadsheet%20you%20may%20already%20have%2C%20just%20making%20sure%20that%20no%20real%20names%20of%20real%20students%20are%20included.%20Use%20the%20names%20of%20favorite%20movie%20characters.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2582600%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20fill%20multiple%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2582600%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3BMy%20reason%20for%20wanting%20each%20student%20to%20have%20their%20own%20worksheet%20is%20so%20that%20I%20can%20have%20their%20personal%20contact%20information%20preprinted%20for%20my%20records%20and%20parents%20wouldn't%20have%20to%20fill%20out%20a%20blank%20information%20form%20for%20me%20because%20as%20someone%20with%204%20children%2C%20I%20know%20how%20tedious%20and%20time%20consuming%20it%20is%20every%20year.%20I%20would%20be%20able%20to%20have%20them%20check%20it%20for%20accuracy%20without%20exposing%20their%20information%20to%20other%20parents.%20I%20could%20just%20run%20the%20report%20the%20district%20gives%20us%20with%20their%20info%20on%20it%2C%20but%20being%20the%20weirdo%20I%20am%20I%20would%20like%20to%20have%20that%20info%20on%20my%20own%2C%20(cute%3F)%20form.%20I%20teach%202nd%20grade.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20I've%20attached%20a%20pdf%20for%20reference.%20TIA%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 do I tell excel that student 'x' name from cell A2 should go into cell B3 in worksheet Student (1) and student 'x' name from cell A3 should go into cell B3 in worksheet Student (2)??? And I should warn you that you may have to use crayons to explain this to me because I am an excel novice. TIA. 

5 Replies

@adevaughn 

 

There are often, in Excel, many ways to accomplish a given objective. In your case, it might be helpful if you gave us a bit more of the complete picture. What's the nature of the data you expect to have on each student, for example, and why do you want to have a separate spreadsheet on each student? I can understand having the ability to print out a full report on a single student, but that doesn't necessarily mean that each student needs to have her or his separate and permanent spreadsheet. It's fairly easy to extract data from a master database, a database containing all relevant into on ALL the students to report, one-by-one on each individual. 

 

So if you could provide a more complete picture of what you're doing here, making sure you're not making assumptions based, say, on prior paper methods of tracking all this. Excel has remarkable abilities to manage data, and a common newbie mistake is to picture it as mainly a bit more automated but basically still a replica of prior paper records with you doing a lot of the "heavy lifting."

 

If it's possible, could you post a copy of whatever spreadsheet you may already have, just making sure that no real names of real students are included. Use the names of favorite movie characters.

@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

best response confirmed by adevaughn (New Contributor)
Solution
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/
It works!!! You're a genius!! Thank you so much!
You're welcome. Now you can dazzle people with your wizardry.