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

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

Secrets of the Office Masters: Combine 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 25.26, for example, consists of tables drawn from Yahoo!'s Finance page and the home pages of MSN Investor and Thestreet.com. We added headings to identify each block, hid several columns that contained nonessential information, and formatted the top 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