LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract information from the list 0-0 Wai Wai ^-^ Excel Worksheet Functions 3 May 12th 06 11:57 AM
Extract information from Multiple sheets bbc1 Excel Discussion (Misc queries) 1 April 18th 06 07:34 AM
Extract information from worksheet bbc1 Excel Discussion (Misc queries) 0 April 5th 06 06:52 AM
Please help: Extract some information from a cell Bobsus5 Excel Discussion (Misc queries) 2 March 7th 06 03:11 AM
how do i extract information from excel and put in certain fields. Novice Excel Discussion (Misc queries) 2 February 9th 05 07:12 PM


All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"