View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
woo woo is offline
external usenet poster
 
Posts: 3
Default Extract Information to another worksheet

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.