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

Extracting Data

You can use criteria to extract all the records that match the criteria and then use the extracted data in other parts of your worksheet or in reports.

To extract data from the database:

1.
Click in any cell in the database (Figure 15.11).

Figure 15.11. Click in any cell in the database.


2.
From the Data menu, choose Filter and then choose AutoFilter.

3.
Click any of the arrow but ons next to the field names to display a list of the entries in that field (Figure 15.12).

Figure 15.12. Select an entry from one of the pull-down lists.


4.
Choose an entry on the list to view only those records that match the entry (Figure 15.13).

Figure 15.13. Only records that match the selected entry appear.


5.
Continue to filter by using the other arrow buttons, if necessary.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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