| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract information from Multiple sheets
I have a workbook with 12 sheets inside of it, each of these sheets is a
series of names and age groups how can I extract the information on a particular group from each sheet to one sheet. ie Sheet A Billy u12 john u14 sarah u16, these are the same across all sheets, but iI need to extract u14 group from each sheet into one, over 200 entries in each sheet, so need macro or a formula. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine multiple Excel sheets? | Excel Discussion (Misc queries) | |||
| extract key words/data from multiple files -dump in new worksheet | New Users to Excel | |||
| insert Rows with Formulas in Place on Multiple Sheets? | Excel Discussion (Misc queries) | |||
| Compare 2 Sheets and Extract Unique Info to a 3rd Sheet | Excel Discussion (Misc queries) | |||
| Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
