Advice for Coding

Hello,
I am desparately trying to save my coworkers hours of work by creating a document for articulating/deciding where to put our students for the following year. I have one sheet where they will enter the data and then in the last column make their suggestions for next year's class NA-D). Right now, I'm sorting that data and then copying and pasting into a new sheet that has four different sections (A-D). Having the four different sections all on one sheet is important so that we can view it and anaylize for equity. I'm wondering if there's a way for information put in that first sheet to automatically appear on the second sheet depending on the class section. I'm probably not explaining it well...so I'll attach what I have so far. Again, if someone out there can help us with this, you'd have the gratitude of about 56 elementary school teachers and 600 students!
Articulation.xlsx

Hi Vonanne,

Welcome to the forum.

Suggest you to change the thread title to reflect the query being asked .. see the forum rules:-
http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>