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

Excel in Practice

A common spreadsheet problem that relates to macros and VBA is having to loop through a variable number of rows of data and do something to rows that meet certain criteria. For example, the worksheet in Figure 32.21 (Sales.xls) contains sales data for more than 400 products. Notice that some of the products in the current year have zero sales values. These are discontinued products.

Figure 32.21. The first few rows of the Sales.xls worksheet. Notice the zero values in the Current Year Sales column.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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