extracting info the best way

S

shiepowk

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
 
B

BrianB

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
========================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data passed to spreadsheet from Form. How to reload the spreadsheetdata into the Form? 5
easiest way to parse column and row info? 4
Extracting specific items from large IE table 6
What is the "VSTO way" for loading data into variables at run time 0
Best/Easiest way to search/find in a string 13
Do I need DLL or COM Addin, Excel Addin 1
Combine two workbooks into one 2
extracting data from one sheet based on data in another - VLookup? 3

Top