Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select a list from several worksheets
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
select a list from several worksheets
I think the options a
#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. "keldo <" wrote: Hi all, If I want to find out a list base on a criteria from several worksheets 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 student (col A), age (col B), sex (col C) I would like to find out lists of student who is under 13yrs old in this school and list the result in a new worksheet. --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select a list in 1 cell by selecting an item from another list in | Excel Discussion (Misc queries) | |||
DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING | Excel Worksheet Functions | |||
how to randomly select a name in a list and then the select the ne | Excel Worksheet Functions | |||
Select all worksheets | Excel Worksheet Functions | |||
How do I select all worksheets | Excel Worksheet Functions |