I am a fairly inexperienced user of excel formulas and have very little
experience with macros, so I was hoping that someone might be able to help me
with a problem that I have been trying to solve. I hope that I have written
my descriptions well enough to be understood.

I need a macro (or formula) that would copy cells (C and D) from my
'Attendance Roster'! worksheet and paste them (into cells B and C) on the
destination worksheet, based on criteria set for column B in 'Attendance
Roster'! worksheet . There would be 3 values that would move data onto 3
separate destination worksheets within the same workbook. It should stop
copying when it comes to an empty cell in column B of 'Attendance Roster'!.

If the destination sheet is empty it should start pasting the copied
information into columns B and C starting with the row 10, or the next empty
cell in column B.

In addition, my description below indicates action for "B10" (and
corresponding "C10 and D10") but the same actions should be applied to all
other cells in columns B (and corresponding C and D) that contain data
beginning with row 10.

Here is my description (lame as it may be) of what I am trying to get excel
to do.

If(Attendance Roster)B10=APS, copy C10 and D10 and paste into (APS Comp
Report) B10 and C10, or into B and C on the first available row .

If (Attendance Roster)B10=COMM, copy C10 and D10 and paste into (COMM Comp
Report) B10 and C10, or into B and C on the first available row.

If(Attendance Roster)B10=EPIMS, copy C10 and D10 and paste into (EPIMS Comp
Report) B10 and C10, or into B and C on the first available row.

I know I am a "novice swimmer wading into deeper waters" but would
appreciate help from anyone who has swam the channel :-) Thanks,

V