"Data" functionality

Topics: Developer Forum
Jul 8, 2012 at 7:42 AM

Is there a way to simulate the functionality given by Excel from the "Data" section? I'm talking about the advanced sorting/subtotals options (I've read PivotTables are not yet possible). For example, right now I'm using the SUBTOTAL function -- which works great, but it doesn't collapse/expand the Subtotals on demand.

Alternatively, is there a way to send VBA code to be executed by Excel? I could easily write a run once script to use Excel's native Subtotal functionality this way.