Urgent Excel Question

kprater6852

New Member
Joined
Nov 16, 2011
Messages
1
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!
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
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,
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,326
Members
414,053
Latest member
Dual Showman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top