This is something that pretty much would be better suited to write out a VBA
code for, which I'm not sure how much knowledge of VBA you have, if any.
Many times, when I am doing quick and dirty type work, I will use formulas
to do the work for me, but if it involves recursive type actions such as in
this situation, it looks to be that sort of deal, I'll generally go ahead
and write out a macro in VBA to address the issue.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

"Woo" wrote in message
...
Hi,
I have a worksheet listing training (one row per training session) that
was
done and then have columns with an "x" under each person who participated
in
that training.

I need to create a means to summarize each persons' training over a
certain
time frame (training date is one of the columns), only pulling the rows
where
that person has an "x" for participation at a training session. Several
columns from each row would need to be copied to the new worksheet in
order
to summarize the training that was attended.

I'd appreciate any advice.