Trying to scrape web data into Excel...not working

Data > From Web tool can be used... but for this site, it's more involved than basic query (see #2 below)

Since the page uses JQuery to load data after initial page load, you can't scrape data by using page URL alone.

There are few methods that you can use.

1. Using VBA pilot IE (browser) to have page load data to container/element. Then scrape data from the loaded page.
- This method will be slow, but usually is more reliable and easiest method.

2. Using Developer Tool in browser of your choice. Trace what action sends request that retrieves data. Then replicate that request via VBA, Data > From Web (Advanced) or other means.
- This is faster method to query. However, will require that you study and deconstruct JQuery request (Request URL, Method, Request Headers needed & Form Data string). It will require significant investment in time/effort up front.

Sample image of request done on the page:
0.JPG

3. If the site has RESTful API. It's probably the best option. But I'm not sure if this site offers one.

This site/page isn't easy to scape, it may be much easier for you to use "Copy" button available in the page to manually transfer info.