Hi all,
I've been beating my head against the wall trying to come up with a solution to this problem, so hopefully someone can point me in the right direction.
In the end, I'm trying to create a script/formula/macro/query (something automated) that can retrieve crime statistics based on some data from a table within a worksheet and then place that crime statistic in the same row within the table that the source info came from. Here's a screenshot of the source table:
Screen Shot 2015-06-26 at 4.41.38 PM.png
I've been trying to setup a web query from http://www.bestplaces.net/crime/zip-...o/denver/80211 (<---example of a full URL) and setup parameters so that the portions after zip-code/ are automatically generated based on the info in the aforementioned table. So far, I've been unsuccessful in executing anything but a static web query. Below, you will see the query that works, as well as the resulting data:
Screen Shot 2015-06-26 at 4.51.24 PM.png
Screen Shot 2015-06-26 at 4.52.54 PM.png
Ideally, I'd like to set something up that could retrieve the values in cells B4 and B5 and also be run for multiple rows (e.g. locations) from the source table.
Any suggestions? I apologize for being a novice in this area. An entire day's worth of internet research coupled with trial and error yielded nothing beyond what you see above.
Bookmarks