Hello all,

I am going to try and explain this as best as possible and hopefully someone can help me out. I am definitely not an excel wizard but have enough computer proficiency to follow any advice you guys could have... I think

Ok so I have a Full Database of students enrolled in classes in my main sheet. I would like something to look through all the entries in the main sheet and extract students that are in a particular class and put their information in another sheet.

So, in my full database I have a row for each student with various information: course enrolled in, student name, email address, phone number, etc and I would like to have an separate sheet for each class (Math, Science, etc) and have the individual databases take each student and all their information from the full database but only if the student is in that class.

I have tried a couple different ways, VBA programming with wordy if and and and while loops, but nothing has quite done it I dont think. At the same time, I feel like there has to be some intrinsic and simple way to do this.

Unfortunately, I would really need the individual database to automatically update if I enter a new student or change a student's information in the full database also.

If this is too complicated or you do not want to totally help me cheat on this project, any tips about how I can grab information from different sheets based on a criteria and then neatly put it into a different sheet would be greatly appreciated.

Thank you so much!