This article shows how you can setup a web query so that you can make the worksheet dynamically update based on values in so called parameter cells. These have been introduced with Excel 97 and have been further enhanced in the versions released after Excel 97. IntroductionĮxcel provides a very useful option to gather data from websites, called web queries. You can find more useful tips from Jan Karel on his website: This post shows you how to dynamically work with data from a website in Excel. Today’s author is Jan Karel Pieterse, an Excel MVP.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |