If a cell has specific data, copy entire row to new worksheet

Kmacteacher Posts 1 Registration date Monday November 7, 2016 Status Member Last seen November 7, 2016 - Nov 7, 2016 at 06:45 AM
 Blocked Profile - Nov 7, 2016 at 05:03 PM
Hello everyone :)
This is my first post and I'm really needing some assistance if at all possible! I am a school teacher, trying to create a spreadsheet.

On the first tab it will look something like this: (please see picture attached.)

I need to create a formula on another tab (same document) saying that:
if under 'CLASS' it has 2.1, then to copy all of the students info over to new tab. (ie would transfer Kwarn and Ji's data.)
Essentially I am trying to create spreadsheet so that all 806 school students info is on the first page, with opportunity, once allocated students to a new class for 2017, all the fields will populate automatically and I wont have to cut/paste 806 students' information to create new class summaries in different tabs.

Any assistance would be so greatly appreciated!!!!!!

1 response

Blocked Profile
Nov 7, 2016 at 05:03 PM
We cannot provide you with turn key solutions, but can help you when you are stuck...post some code and let us know where you are stuck. I encourage you to RECORD a MACRO and then observe how the macro writes out the commands you recorded. Then change the variables to suit your needs!