Please Help!!!

  • Thread starter Thread starter wasi64
  • Start date Start date
W

wasi64

I am working with an Excel worksheet. The worksheet contain students
schedule for a high school. Most of the students are having two rows.
The first row contains student and their class name. The second rows
containing the room number bellow the class name. Some students are
occupying 4 rows. First two rows are same for every one but other two
rows containing additional class at the same period. Example: at the
4th period some students have 'GYM' for 3 days and 'LAB' for 2 days.
This ‘LAB’ is occupying extra 2 rows.

Now I like cut this 'LAB' class and pest that to the same rows that
contains the name and room number of the student.

How can I do that? I have +/- 4000 students.
 
See my reply under your earlier posting:

Copy and Pest in Excel

Regards,
Mark Graesser
(e-mail address removed)

----- wasi64 wrote: -----

I am working with an Excel worksheet. The worksheet contain students
schedule for a high school. Most of the students are having two rows.
The first row contains student and their class name. The second rows
containing the room number bellow the class name. Some students are
occupying 4 rows. First two rows are same for every one but other two
rows containing additional class at the same period. Example: at the
4th period some students have 'GYM' for 3 days and 'LAB' for 2 days.
This ‘LAB’ is occupying extra 2 rows.

Now I like cut this 'LAB' class and pest that to the same rows that
contains the name and room number of the student.

How can I do that? I have +/- 4000 students.
 
Back
Top