Extract result from Subtotal, Groupings, Filters

DigDB

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

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

Practice file - extract-subtotal-demo.xls (16k)
Visible rows will selected. Reconfirm. Click OK to extract (copy by value) them to a new sheet.

Subtotal extracted:

Extract result from Excel or DigDB Filters

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

Practice file - extract-filter-demo.xls (16k)
Visible rows will selected. Reconfirm. Click OK to extract (copy by value) them to a new sheet.

Subtotal extracted:

Need more?

Browse the complete list of DigDB's powerful features listed on the front page.
If you see errors or things not working, check out our error reference page.

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 and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.