|
 |
        |
|
INDIVIDUAL PRODUCTS:
PRODUCT COLLECTIONS: |
The Data Extraction Assistant for Microsoft Excel helps you extract data from one worksheet to many worksheets. It can create new worksheets as needed. The extraction can be to the current workbook, to any open workbook, or to a new workbook. It is based on the entries in any column of the data that you specify. The Data Extraction Assistant also provides a feature that allows you to sort the sheets in alphabetical order and to quickly go to any worksheet. These features, along with a help and exercise file to teach you how to use the product, are available from the Data Extraction Assistant toolbar. The toolbar only appears when you are using the Data Extraction Assistant. When you click on the first button on the toolbar the following dialog appears:
When you use the first option, extract data to different worksheets, the following dialog appears to provide a set of options for the data extraction:
Following this dialog is another set of options that allows you to color and mark processed data:
When the extraction is completed you can then go to any of the worksheets using the sheet navigation tool included in the Data Extraction Assistant. If you need to create individual workbooks from the worksheets, the Data Extraction Assistant has an option on the first dialog above that creates individual workbooks.
| |
| Copyright 2008 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC. Microsoft and Excel are trademarks or registered trademarks of Microsoft Corporation. |
