Hi all,

If I want to find out a list base on a criteria from several worksheet
into a new worksheet, how can I do?

for example,

There have a xls file called school.xls including several worksheet
Each worksheet contain a each class information, eg name of studen
(col A), age (col B), sex (col C)

I would like to find out lists of student who is under 13yrs old i
this school and list the result in a new worksheet

--
Message posted from http://www.ExcelForum.com