Hi HSprincipal
Maybe the filter example will help on this page
http://www.rondebruin.nl/copy3.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"HSprincipal" wrote in message ...
How do you collect data form multiple excel spread sheets? For example I
would like to find a name of a student and collect all of the final grades
form different teachers excel gradebooks.