Urgent Excel Question

[kprater6852]

I have an excel spreadsheet with students names and grades for all exams and averages for a semester. I need each student to have their own sheet with these grades but i don't want to have to go in an copy and paste all of them individually. I know there is a way to do this right under my fingertips, I juts cannot figure it out! Please help!

 

[Marcelo Branco]

Maybe this can help

http://www.datapigtechnologies.com/freeware.htm

Excel Explosion 3.0 - See the tutorial

M.

 

[Smitty]

Welcome to the Board!

If you put the data into a Pivot Table, then use Student Name as a filter you can use the Pivot Table Report Filter Pages feature to build individual reports.

You can also post a shot of your sheet (see the link in my sig) and someone might be able to come up with some code to do it.

HTH,

 

[xtremegrump]

Give this a try

http://www.mrexcel.com/forum/showthread.php?t=594549

Kevin
Excel2007