Excel Sorting Question

[jeffingle]

I have a master sheet that is populated by a form. I want to take information from that sheet and place it into 4 other sheets based on the value in a specific cell. The master sheet contains data for four different grade levels. I want to be able to look in the grade column and copy all of the rows that have 8th grade data into a separate sheet, 7th grade into a separate sheet, 6th and 5th. Thanks in advance for the help.

[Paul]

Hi Jeffingle, welcome to the forum.

This is certainly possible. Do you have any of this setup yet? It will probably be easiest to upload a copy of your workbook after replacing any sensitive data (e.g. replace real names with fake names) so we can provide solutions without much trial and error.

[jeffingle]

I have attached a very scaled down version of the spreadsheet I am using. The current version has a little over 325 records in it. Thanks again for the help.

[Paul]

A few questions:

1. Do you ever remove data from the Master sheet? If so, what should happen to the data that was copied to the other sheet(s)?
2. Do you ever change the Grade Level data for users? If so, what should happen to the data on the previous grade level sheet?
3. Why are you using columns D:H for 5th, I:M for 6th, N:R for 7th and S:W for 8th? Couldn't all the student data be in D:H, then we can copy out the data based on the value in column C?