I have a problem and am not very familiar with VBA.
What I need to do is check a row of data one at a time (there are abou
3000 total rows) looking for a class number (the class numbers are i
different columns within the row). When I find that class number withi
the row I need to *copy* the row to another sheet. I am simply trying t
grab all of the students in certain classes and paste them on anothe
sheet.

Here is a sample of the data:
Adams gadams21 041184 84022 84260
Adams hadams4 111591 83772
Adams dadams25 041645 84020 84282
Adams madams3 082981 83969
Adams sadams9 120369 81838 84025 86460

The first column is last name (yes, I have changed the data...none o
it is sensitive).
The second column is user name.
3rd column is birthday.
Remaining columns are classes they are in (can vary; some can be in
classes, some in 1).

Any help would be greatly appreciated.

Thanks,

busspee

--
busspee
-----------------------------------------------------------------------
busspeed's Profile: http://www.excelforum.com/member.php...fo&userid=1482
View this thread: http://www.excelforum.com/showthread.php?threadid=26463