• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Extending Office Data Analys... > Extending the Data Analysis Features...

Extending the Data Analysis Features in Microsoft Excel

Because many of the Excel data analysis tasks that you will do on a daily basis involve sorting, filtering, and subtotaling data records, let’s start with an example of how to automate these straightforward tasks. The code we’ll examine in the next several sections is attached to the BookSale.xls file in the Chap11 folder. If you want to run the code samples as you read, go ahead and open the file now.

Sort, Filter, and Subtotal Lists of Records

You can use code similar to the following SortSales subroutine to sort a list of data records. Using code such as this is a good way to ensure that records are always sorted when an Excel workbook is opened.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint