![]() One thing I thought about later is you might not what a separate worksheet for each student.Ī quick and dirty way to put all the student tests in one would be to set it up as described but each time you are going to paste answers into the student tab, make a copy of the combined tab first.Īfter pasting in the student tab and the data is in the copy of the combined tab, select all data in that copy of combined, copy the data into the clipboard, then Paste As Values. The Address part is saying 'for the row number, look at the question number column, for the column, always do the first column, combine them and look for that cell on this other sheet' The Indirect formula is just saying 'I want the contents of the cell the Address formula returns and not the cell reference (e.g., A1)" It was either create that question number column or you would have to manually modify the formula for each row.įill down the questions column then you can select the first two rows of formulas and fill them down. I first tried it without out that and just tried to fill down the formula column. I can get that column to fill down the numbers by having the first row be 1 and the next one be A1-1. I had to put a questions/row column so that there was some reference for the formula to look at. Yes, pasting the answers in the teachers tab and pasting the student answers in the student tab will make them every other row on the combined tab. You're getting me excited lookup how to use these things that should not be too difficult: Save this whole thing as a template and use it with any test With this table you can do actual excel make a little dashboard that fetches the students answers from the dataset using a variable you select from a drop-down menu whereas you just keep the answers static and visible. If formatted the same this could be macrod as well just try out record macro after you got the hang of the order of itĮither that or just make 1 dataset tab with all the data, categorize (student# / ANSWER) and number the questions. ![]() Have another tab with answers, then either manually move or write a template for formulas that fetch the correct answers that you can copy and paste into the main tab with the students answers Use import from external source: text and play with the wizard to get the data into Excel Thank you so much! I really appreciate it! Is there perhaps a way I could select every other row and then paste the lines into those rows only? Doing this for both of the documents? I tried using a formula I found online, but I'm not sure if that's the formula I should be using for this. So I would like to paste a line of data from doc 1, and then a line of data from doc 2, and then a line of data into doc 1, and then a line of data into 2, so on and so forth. So I would like to use excel to paste the student's work in alternating excel rows, and the correct teacher's copy into alternating rows beneath that, so that making corrections and proofreading will become easier with both right there. ![]() I have a student's word document which I need to correct, and a teacher's word document containing the correct answers. Hi! The situation is that I have two different word documents and I would sort of like to merge the data from both. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |