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

Chapter 28. Working with Lists and Datab... > Secrets of the Office Masters: Combi...

Secrets of the Office Masters: Combining Data from Several Web Sources in a Custom Page

Do you regularly check several Web pages during the day to gather information? Excel's capability to create live links to Web data might let you combine parts of each Web page into a single worksheet. You can then save the resulting worksheet as a Web page and put all those bits and pieces of data into a single easy-to-update location.

The page shown in Figure 28.27, for example, consists of tables drawn from Yahoo!'s Finance page and Microsoft MoneyCentral. We added headings to identify each block, hid several columns that contained nonessential information, and formatted the two blocks as Full HTML.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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