Macro To Divide Rows by Worksheet

[m.g.gilliland]

Hello,

I need to create a macro that will create a new worksheet that contains all of the rows that have the same value in cell A (which is a student ID number) and if possible, name the worksheet with value of cell B. The last step is not mandatory, but would be nice.

I also need the first row in every worksheet to be the same:
Student ID
Last, First
Last Name
First Name
State Student ID
Intervention Name
Intervention Start Date
Intervention
End Date
Date Minutes
Received Intervention
Comments


There are about 12 thousand rows and about 150 unique student IDs. Thanks!

[Mad-Mizer]

I don't find your requirements very clear. You want all the rows copied to another sheet? Instead of Cell A, did you mean column A? You want to name each worksheet with the student's name? You'll have to be a little clearer.

[walruseggman]

Try this. It's adapted from some old code of mine, so I realize that temporarily coloring a cell to indicate it's been used isn't the best method. But this should work.

Please Login or Register  to view this content.