DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact

Extract result from Subtotal, Groupings, Filters

Excel's Subtotal, groupings, AutoFilter, Advanced Filter, DigDB's complex filter, table match, filter uniques, all hide some rows and display the visible rows as the result of the action. DigDB's Extract Result function allows you to extract the visible rows to a new sheet in one click. Or, if you prefer, you can also delete the hidden rows to keep only the result in the current sheet.

Extract result from Subtotal or Excel Groupings

  1. Select a single cell in the table area, invoke 'DigDB->Extract Result->Copy Visible Rows to New Sheet', the table will be auto-selected.

    Extract result - subtotal, groupings, filters
    Practice file - extract-subtotal-demo.xls (16k)

  2. Visible rows will selected. Reconfirm. Click OK to extract (copy by value) them to a new sheet.

    Extract result - subtotal, groupings, filters

    Subtotal extracted:

    Extract result - subtotal, groupings, filters

Extract result from Excel or DigDB Filters

  1. Select a single cell in the table area, invoke 'DigDB->Extract Result->Copy Visible Rows to New Sheet', the table will be auto-selected.

    Extract result - subtotal, groupings, filters
    Practice file - extract-filter-demo.xls (16k)

  2. Visible rows will selected. Reconfirm. Click OK to extract (copy by value) them to a new sheet.

    Extract result - subtotal, groupings, filters

    Subtotal extracted:

    Extract result - subtotal, groupings, filters

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact (resume builder | wehtwrjw )

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.