select a list from several worksheets

K

keldo

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
 
D

Dave Peterson

I think the options are:

#1. Copy all your data into one worksheet. Then data|filter|autofilter.
paste all the visible rows to a new worksheet.

#2. Cycle through all the worksheets and filter them. Paste each worksheet's
visible cells under the previous worksheet's data on the new worksheet.
 
Top