Hello all,

I am looking for a way to extract and copy all rows that have a specific value in column C.

To be more specific, I have a data set that looks like the following

Name Grade Class Score 1 Score 2 Score 3
Student 1 6th A 90 95 80
Student 2 7th B 100 100 100
Student 3 7th A 75 90 95
Student 4 6th A 85 85 100
Student 5 8th B 95 70 95
Student 6 6th A 100 80 95
Student 7 8th B 95 70 85
Student 8 8th A 95 80 85

The actual data set is much larger, but it looks like the example above.

What I am trying to do is add a set of rows to dissagregate the data by separating it into students in class A and students in class B. Once it is dissagregated, I want the entire sheet to look as follows:

Name Grade Class Score 1 Score 2 Score 3
Student 1 6th A 90 95 80
Student 2 7th B 100 100 100
Student 3 7th A 75 90 95
Student 4 6th A 85 85 100
Student 5 8th B 95 70 95
Student 6 6th A 100 80 95
Student 7 8th B 95 70 85
Student 8 8th A 95 80 85


Dissagregated
Class A:
Name Grade Class Score 1 Score 2 Score 3
Student 1 6th A 90 95 80
Student 3 7th A 75 90 95
Student 4 6th A 85 85 100
Student 6 6th A 100 80 95
Student 8 8th A 95 80 85
Averages

Class B:
Name Grade Class Score 1 Score 2 Score 3
Student 2 7th B 100 100 100
Student 5 8th B 95 70 95
Student 7 8th B 95 70 85
Average

Here's the catch: The spreadsheet is both huge and dynamic, so I am trying to find a way to have excel do this automatically as data is entered, rather than manually sorting it every time changes are made.

I am very familiar with formulas, but I have literally no experience with macros or programming. I tried searching through and reading over lots of other posts, but have not had much luck. Any help would be greatly appreciated.

Thanks ahead of time.