Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extracting info the best way
I have a spreadsheet that has information about trainers, and their teaching schedules. I want to be able to extract all of the information for each individual trainer to give them their shedules for the term. I want to pull out the trainer name, the class being taught and the time of the class, in one step, where all the other information pertaining to location, level, etc comes with it. Right now I'm filtering and using the copy/paste method for each individual trainer. Is there a shorter method to use to perform this task? Thank you kindly ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
extracting info the best way
Hopefully your data is in table format, when you could probably make a
Pivot Table using the trainer name as a Page field. Regards BrianB ================================================== ====== shiepowk wrote in message ... I have a spreadsheet that has information about trainers, and their teaching schedules. I want to be able to extract all of the information for each individual trainer to give them their shedules for the term. I want to pull out the trainer name, the class being taught and the time of the class, in one step, where all the other information pertaining to location, level, etc comes with it. Right now I'm filtering and using the copy/paste method for each individual trainer. Is there a shorter method to use to perform this task? Thank you kindly ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting all info in Cell except last 3 characters | Excel Discussion (Misc queries) | |||
Extracting info from web pages | Excel Discussion (Misc queries) | |||
Extracting info to new tables | Excel Discussion (Misc queries) | |||
Comparing files and extracting info. | Excel Worksheet Functions | |||
extracting contact info to a database | Excel Discussion (Misc queries) |