| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort info
Is it possible to sort information containing certain data from one sheet
into other separate sheets/workbooks for that particular data? Ex.. Main sheet contains all information on baseball teams. I want to sort out the cubs, put the data on it's own worksheet, and update automatically. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sort info
Look at "Filter" in help. That will allow you to group all the "cub" data,
then you can copy/paste to the other sheet. HTH Otto "Newbi" wrote in message ... Is it possible to sort information containing certain data from one sheet into other separate sheets/workbooks for that particular data? Ex.. Main sheet contains all information on baseball teams. I want to sort out the cubs, put the data on it's own worksheet, and update automatically. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenating info from several cells into the one above | Excel Discussion (Misc queries) | |||
| Reflecting info between an excel file and a word one or two excel file. | Links and Linking in Excel | |||
| Select rows and sort based on type | Excel Discussion (Misc queries) | |||
| Excel should let me group rows of info and then sort them | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Linear Mode
