Return filtered values into report worksheet based on filtered valueon the data worksheet

[dicko1]

I have two worksheet, one with data and one that is a report card. I
would like to be able to filter the data and have the report worksheet
show the results. For example:


If the data sheet has this info

Technician Craft Hours
Bob Custodial 100
Steve HVAC 200
Ryan HVAC 178
Sara Electrical 152
Will Alarms 90

....and I want the report card sheet to show this if I filter by HVAC

Technician Hours
Steve 200
Ryan 178

Thanks,

 

[Debra Dalgleish]

You can use an Advanced Filter, as described here:

http://www.contextures.com/xladvfilter01.html#ExtractWs

There are sample files here:

http://www.contextures.com/excelfiles.html

Under Filter, look for:
FL0001 - Product List by Category
FL0005 - Phone List for Selected Name