How can I create a sheet for each row in Excel?
February 9, 2012 6:45 AM Subscribe
ExcelFilter: Is there a way to create a sheet for every row in Excel?
posted by monkeymadness to computers & internet (15 answers total) 3 users marked this as a favorite
I use Excel for grades (Blackboard still has a long way to go to catch up to ease and control of Excel), and I give loads of assessments (quizzes, homework, exams). Each row represents a different student. When I want to show a student how they're doing in each category I have to cover up everyone else's grades or copy that student's row of grades and paste them into a new sheet. What I would like is a way to to automatically generate a sheet for each student that updates along with the information in the master sheet that I can show them when I need to. I could also potentially include a chart or two showing them where they're having difficulty. I know other faculty who do this sort of thing by hand for each student, but I'm not willing to go that far. I'm hoping there's something simple that I'm just missing.
Failing that, is there some method I haven't thought of that will easily black out every row but one (or possibly two, including the top row of assignment labels)?