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

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,

You can use an Advanced Filter, as described he

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

There are sample files he

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

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


dicko1 wrote:
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
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com