Data Extraction Assistant

A data related add-in product for Microsoft Excel

Do you have these problems:

• Need to extract data to other worksheets based on column entries?
• Worksheets you want to alphabetize for easy access?
• Need to create individual workbooks from multiple worksheets in one workbook?

The Data Extraction Assistant can solve all of these problems and more!  

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.